Name: Health and Safety Executive
Price: 53 GBP
Availability: InStock

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
					<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				<h3>Learning Objectives</h3>Introduction , Getting Started with Excel , Creating Workbooks and Using Templates , Entering Data , Excel Formula Basics , Adjusting a Worksheet , Formatting and Aligning Data , Using Cell Styles and Themes , Inserting Objects and Graphics , Proofing a Workbook , Printing an Excel File , Managing Worksheets , Navigating and Viewing Excel Files , Conclusion <h3>Pre-Requisites</h3>Basic Computer Skills <h3>Description</h3>Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><table>				<tbody><tr>
					<td colspan="4">Section 01</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: What is Excel</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Opening Excel</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Navigating the Excel User Interface-v2</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Navigating the Excel User Interface</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Using the Excel Ribbon</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Understanding Excel Worksheet Components</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Using the Backstage View</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 02</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Creating a New Workbook</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Saving an Excel Workbook</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Using the Accessibility Checker</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Using the Accessibility Checker-v3</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 03</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Navigating a Worksheet by Mouse or Keyboard</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Understanding Excel Data Types</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Using the Inking Tools</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Using the Inking Tools-v3</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Working with Cell and Range Addressing</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Using Various Data Selection Techniques</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Working with Common Excel Commands</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 08: Using Flash Fill and Autofill</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 04</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: What are Formulas and Functions</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Understanding the Components of a Formula</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Understanding Calculation Hierarchy and the Order of Operations</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Creating Basic Formulas</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Working with Basic Functions and AutoSum</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Using Cell References</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Using the Quick Analysis Tool</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 05</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Modifying Columns and Rows</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Hiding and Unhiding Columns and Rows</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 06</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Formatting and Aligning Data</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Merging Data</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Wrapping Text and Adjusting Orientation</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Formatting Numbers</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Using the Format Painter</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 07</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Using Cell Styles</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Applying Themes</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 08</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Inserting and Formatting Images and Shapes</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Inserting and Formatting SmartArt</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Working with Icons</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Inserting Hyperlinks</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Inserting Symbols and Equations</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Inserting WordArt and Text Boxes</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Inserting 3-D Models</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 08: Arranging Objects</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 09</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Using Find and Replace</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Using Go To and Go To Special</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Using the Spell Checker</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Using the Thesaurus and Translation Features</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Using the resolve Feature-v3</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 10</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Printing and Previewing Excel Files</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Creating Custom Margins and Scaling</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Adding Headers and Footers</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Formatting a Page with the Page Layout Tab</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Printing Titles and Specific Worksheet Areas</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Exporting to PDF-v3</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Exporting to PDF and XPS</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 11</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Renaming and Coloring Worksheet Tabs</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Adding, Deleting and Navigating Worksheets</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Hiding and Unhiding Worksheets</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 12</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Viewing Workbooks</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Using Zoom Tools</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Configuring Sheet Options</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Using the Freeze Panes and Split Commands</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Adjusting Worksheet Properties</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Viewing Workbook Statistics-v3</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Course Recap</td>
				</tr>
								<tr>
					<td></td>
					<td>Recap</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Final Exam - Excel 365 Beginner</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
				</tbody></table>

iStudy UK

Office Skills & Productivity

Computing Skills

Office Skills

Computer Skills

Microsoft Excel

Microsoft Office

Excel 365 Beginner

General Admission

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
			<blockquote>Microsoft Office Excel is a great tool used to create and format spreadsheets. Spreadsheets allow you to organise information in rows and tables and analyse it with automatic mathematics. Spreadsheets are also very commonly used to perform various types of calculations. Regardless of whether you are completely new to Excel or upgrading from an older version, this Excel 2007 course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of experience, knowledge and teaching techniques to create an easy-to-use course that can be customised to meet your personal learning needs. </blockquote>
<h3>Course Highlights</h3>
Accredited Diploma in Microsoft Excel 2007 is an award winning and the best selling course that has been given the CPD Certification &amp; IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector.
It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Diploma in Microsoft Excel 2007 into 26 modules for teaching you everything you need to become successful in this profession.
To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 22 hours, 30 minutes hours and it is also possible to study at your own pace.
We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email.
For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website.
<h3>Why You Should Choose Accredited Diploma in Microsoft Excel 2007</h3>
<ul>
<li>Lifetime access to the course</li>
<li>No hidden fees or exam charges</li>
<li>CPD Accredited certification on successful completion</li>
<li>Full Tutor support on weekdays (Monday - Friday)</li>
<li>Efficient exam system, assessment and instant results</li>
<li>Download Printable PDF certificate immediately after completion</li>
<li>Obtain the original print copy of your certificate, dispatch the next working day for as little as £9.</li>
<li>Improve your chance of gaining professional skills and better earning potential.</li>
</ul>
<h3>Who is this Course for?</h3>
Accredited Diploma in Microsoft Excel 2007 is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills.
As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds.
<h3>Requirements</h3>
Our Accredited Diploma in Microsoft Excel 2007 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
<h3>Career Path</h3>
You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our
Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume.<table>				<tbody><tr>
					<td colspan="4">Microsoft Excel 2007 for Beginners</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening and Closing Excel</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Your First Worksheet</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Working with Excel Files</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Viewing Excel Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Printing Excel Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Building Formulas</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Using Excel Functions</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Using Time Saving Tools</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Formatting your Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - More Formatting</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Excel 2007 Advanced Level</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - SmartArt</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Inserting Objects</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Creating Charts</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Creating Pivot Tables</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Working with Pivot Tables</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Creating Pivot Charts</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Solving Formula Errors</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Using What-If Analysis</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Managing Your Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Grouping and Outlining Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4"> Activities</td>
				</tr>
								<tr>
					<td></td>
					<td>Activities-Accredited Microsoft Excel 2007 for Beginners</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Activities-Microsoft Excel 2007 Advanced Level CPD &amp; IAO Accredited- CPD Accredited</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
				</tbody></table>

Microsoft MS-700

Microsoft Certification

Certificate in Further Education & Training (Cert Ed)

European Computer Driving Licence (ECDL)

Accredited Diploma in Microsoft Excel 2007

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
			Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. Microsoft Excel 2010 is the spreadsheet application in the MS Office 2010 suite. You will begin with the fundamentals, assembling a strong foundation that will give you further knowledge as you advance into intermediate and advanced level topics. By the end of this course, you will have mastered the most important Excel 2010 tools and come out with confidence to finish any Excel assignments with proficiency and grace.
<h3>Course Highlights</h3>
Professional Diploma in Microsoft Excel 2010 is an award winning and the best selling course that has been given the CPD Certification &amp; IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector.
It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Professional Diploma in Microsoft Excel 2010 into 39 modules for teaching you everything you need to become successful in this profession.
To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 8 hours hours and it is also possible to study at your own pace.
We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email.
For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website.
<h3>Why You Should Choose Professional Diploma in Microsoft Excel 2010</h3>
<ul>
<li>Lifetime access to the course</li>
<li>No hidden fees or exam charges</li>
<li>CPD Accredited certification on successful completion</li>
<li>Full Tutor support on weekdays (Monday - Friday)</li>
<li>Efficient exam system, assessment and instant results</li>
<li>Download Printable PDF certificate immediately after completion</li>
<li>Obtain the original print copy of your certificate, dispatch the next working day for as little as £9.</li>
<li>Improve your chance of gaining professional skills and better earning potential.</li>
</ul>
<h3>Who is this Course for?</h3>
Professional Diploma in Microsoft Excel 2010 is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills.
As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds.
<h3>Requirements</h3>
Our Professional Diploma in Microsoft Excel 2010 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
<h3>Career Path</h3>
You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. <table>				<tbody><tr>
					<td colspan="4">Microsoft Excel 2010 for Beginners</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td>FREE </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening and Closing Excel</td>
					<td>FREE </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Your First Worksheet</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Working with Excel Files</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Viewing Excel Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Printing Excel Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Building Formulas</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Using Excel Functions</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Using Time Saving Tools</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Formatting Your Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Advanced Formatting Tools</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Excel 2010 Intermediate Level</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Working with Permissions and Options</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Sharing Workbooks</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Performing Advanced Formula and Function Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Working with Array Formulas</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Working with Functions</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Working with Macros</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Working with Forms</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Applying Advanced Chart Features</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Working with PivotTables and PivotCharts</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Using the Automated Analysis Tools Add -In</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Excel 2010 Advanced Level</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - SmartArt and Objects</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Auditing</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Creating Charts</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Creating Pivot Tables</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Working with PivotTables and PivotCharts</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Macros</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Solving Formula Errors</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Using What If Analysis</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Managing Your Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Grouping and Outlining Data</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Activities</td>
				</tr>
								<tr>
					<td></td>
					<td>Activities-Accredited Microsoft Excel 2010 for Beginners</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Activities-Microsoft Excel 2010 Intermediate Level</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Activities-Certified Microsoft Excel 2010 Advanced Level- CPD &amp; IAO Accredited</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Mock Exam- Professional Diploma in Microsoft Excel 2010</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Final Exam- Professional Diploma in Microsoft Excel 2010</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
				</tbody></table>

Professional Skills Course (PSC)

Diploma in Professional Studies (DPS)

Professional Diploma in Microsoft Excel 2010

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
					<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				<h3>Learning Objectives</h3>Introduction , Linking Workbooks and Worksheets , Working with Range Names , Sorting, Filtering, and Subtotaling , Analyzing and Organizing with Tables , Using Conditional Formatting , Displaying Data Graphically , Understanding PivotTables, PivotCharts, and Slicers , Working with Advanced PivotTables and PowerPivot Features , Conclusion <h3>Pre-Requisites</h3>Excel 365 Introduction course or equivalent knowledge or experience. <h3>Description</h3>In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features.					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><table>				<tbody><tr>
					<td colspan="4">Section 01</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Linking Workbooks and Worksheets</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Linking Workbooks with 3D References</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Understanding the Consolidate Feature</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 02</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: What are Range Names</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Creating Range Names Using the Name Box and Define Name</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Creating Range Names Using Create from Selection</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 03</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Understanding the Differences Between Sorting and Filtering</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Sorting Lists</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Filtering Lists</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Creating Subtotals</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 04</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Creating Tables and Understanding the Benefits</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Understanding the Elements of a Table</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Formatting a Table</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Sorting and Filtering Tables</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Filtering with Slicers</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Calculating with Tables</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Removing Erroneous Table Data</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 08: Exporting, Refreshing, and Converting Tables</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 05</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: What is Conditional Formatting</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Conditional Formatting Highlight Cells and Top Bottom Rules</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Conditional Formatting Data Bars, Icon Sets, and Color Scales</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Using Custom Fonts and Colors</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Using Custom Conditional Formatting</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Modifying or Removing Conditional Formatting</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 06</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: What are Charts</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Creating Charts</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Understanding Chart Elements</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Modifying Chart Elements</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Changing and Moving Charts</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Filtering a Chart</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Formatting Charts</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 08: Adjusting Numbering</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 09: Creating Dual Axis Charts</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 10: Forecasting with Trendlines</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 11: Creating a Chart Template</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 12: Displaying Trends with Sparklines</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 07</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: What is a PivotTable</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Creating a PivotTable</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Working with the PivotTable Fields Pane</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Basic Data Organization and Analysis with PivotTables</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Formatting PivotTables</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Creating a PivotChart</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 07: Modifying and Formatting a PivotChart</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 08: Adding Slicers and Timeline Slicers</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 09: Formatting Slicers</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 10: Using the Ideas Feature</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 08</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 01: Using the PivotTable and PivotChart Wizard</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 02: Adding a Calculated Field</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 03: Adding a Calculated Item</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 04: Applying Conditional Formatting to a PivotTable</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 05: Creating Filter Pages for a PivotTable_1</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lesson 06: Enabling the PowerPivot Add: In</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Final Exam - Excel 365 Intermediate</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
				</tbody></table>

Excel Analytics

Microsoft AZ-104

Microsoft AZ-303

Excel 365 Intermediate

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
			If you are looking forward to advance your skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface, this Excel 2016 Advanced will be the perfect choice for you!
Through the course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Additionally, you will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in your worksheets and workbooks. You will also learn about Excel's many collaboration features, as well as how to import and export data to and from your workbooks.
<h3>What Will I Learn?</h3>
<ul>
<li>Use Advanced IF Statements</li>
<li>Use Advanced Lookup Functions</li>
<li>Use Complex Logical and Text Functions</li>
<li>Auditing Formulas</li>
<li>Working with What-If Analysis Tools</li>
<li>Protecting Worksheet and Workbook</li>
<li>Use Advanced PivotTables and PowerPivot Tools</li>
<li>Automate with Macros</li>
<li>Work with Form Controls</li>
<li>Ensure Data Integrity</li>
<li>Collaborate in Excel</li>
<li>Import and Export Data to a Text File</li>
</ul>
<h3>Requirements</h3>
<div>
<ul>
<li>Excel Introduction and Intermediate courses or equivalent experience.</li>
</ul>
<h3>Who is the target audience?</h3>
<ul>
<li>Students who want to expand their Excel knowledge.</li>
</ul>
</div><table>				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td>FREE </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Using Advanced IF Statements</td>
				</tr>
								<tr>
					<td></td>
					<td>Summarize Data with SUMIF</td>
					<td>FREE </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Summarize Data with AVERAGIF</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Summarize Data with COUNTIF</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Using Advanced Lookup Functions</td>
				</tr>
								<tr>
					<td></td>
					<td>Using VLOOKUP with TRUE to find an Approximate Match</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Using HLOOKUP TRUE to find an Approximate Match</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Using the Index Function</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Using the Match Function</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating a Combined Index and Match Formula</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Comparing Two Lists with VLOOKUP</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Comparing Two Lists with VLOOKUP and ISNA</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Using Complex Logical and Text Functions</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating a Nested IF Function</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Using the IFERROR Function</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Using the LEN Function</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Using the TRIM Function</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Using the Substitute Function</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Formula Auditing</td>
				</tr>
								<tr>
					<td></td>
					<td>Showing Formulas</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Tracing Cell Precedents and Dependents</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding a watch Window</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Error Checking</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">What-If Analysis Tools</td>
				</tr>
								<tr>
					<td></td>
					<td>Using the Scenario Manager</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Using Goal Seek</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Analyzing with Data Tables</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Worksheet and Workbook Protection</td>
				</tr>
								<tr>
					<td></td>
					<td>Protection Overview</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Excel File Password Encryption</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Allowing Specific Worksheet Changes</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding Protection to only Certain Cells in a Worksheet</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Additional Protection Features</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Advanced Use of PivotTables and PowerPivot</td>
				</tr>
								<tr>
					<td></td>
					<td>Using the Pivot Tables Charts Wizard</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding a Calculated Field</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding a Caculated Item</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Apply Conditional Formatting to a Pivot Table</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Using Filters in the Pivot Table Fields Pane</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Filter Pages for a Pivot Table</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Enabling a Power Pivot Add In</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Automating with Macros</td>
				</tr>
								<tr>
					<td></td>
					<td>What are Macros</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Displaying the Developer Tab and Enabling Macros in Excel</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating a Basic Formatting Macro</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Running a Macro</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Assigning a Macro to a Button</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating a More Complex Macro</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Viewing and Editing the VBA Code for an Existing Macro</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding a Macro to the Quick Access Toolbar</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Working with Form Controls</td>
				</tr>
								<tr>
					<td></td>
					<td>What are Form Controls</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding Spin Buttons and Check Boxes to a Spreadsheet</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding a Combo Box to a Spreadsheet</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Ensuring Data Integrity</td>
				</tr>
								<tr>
					<td></td>
					<td>What is Data Validation</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Restricting Data Entries to Whole Numbers</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Validation Restricting Data Entry to a List</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Validation Restricting Data Entry to a Date</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Validation Restricting Data Entry to Different Text Lengths</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Composing Input Messages</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Composing Error Alters</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Finding Invalid Data</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Editing and Deleting Data Validation Rules</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Collaborating in Excel</td>
				</tr>
								<tr>
					<td></td>
					<td>Working with Comments</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Printing Comments and Errors</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sharing a Workbook</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Tracking Changes in a Workbook</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Working with Versions</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sharing Files via Email</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Importing and Exporting Data to a Text File</td>
				</tr>
								<tr>
					<td></td>
					<td>Importing a Text File</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Exporting a Text File</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td></td>
					<td>Course Recap</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Course Certification </td>
				</tr>
				</tbody></table>

Access VBA

Microsoft Access

Excel 2016 Advanced

With a single payment you will gain access to Event Planner including 10 additional premium courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Courses are included with this Event Planner Complete Bundle: <ul> <li>Course 01: Event Planner</li><li>Course 02: Event Management</li><li>Course 03: Catering Management</li><li>Course 04: Business Analysis Level 3</li><li>Course 05: Interior Design Professional Diploma</li><li>Course 06: Effective Communication Skills</li><li>Course 07: Basic Adobe Photoshop</li><li>Course 08: Professional Photography Diploma</li><li>Course 09: Customer Relationship Management</li><li>Course 10: Baking and Cake Decorating Level 2</li><li>Course 11: Health and Safety at Workplace</li></ul> If you want to gain a solid understanding of Event Planner and fast track your dream career, then take a step in the right direction with this industry-standard, comprehensive Event Planner course designed by expert instructors. The Event Planner will cover a comprehensive range of 12, you'll have 24/7 online access to the study materials, introductory videos, assessment tests, study resources and tutor support for a lifetime. The Event Planner will help you to develop your skills, confidence and knowledge of this sector, helping to add real value to your CV and personal development. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Event Planner has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Event Planner is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Whether you are looking to brighten up your CV, just starting out in the industry, looking for a career change or just fancy learning something new, this online Event Planner course is perfect! Benefits you'll get choosing Apex Learning for this Event Planner: <ul> <li>One payment, but lifetime access to 11 CPD courses</li><li>Certificates, student ID for the title course included in a one-time fee</li><li>Full tutor support available from Monday to Friday</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules taught 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>Course 01: Event Planner <ul> <li>Module 01: Introduction to Event Management</li><li>Module 02: Role of an Event Planner</li><li>Module 03: Event Classification</li><li>Module 04: Events and Clients</li><li>Module 05: Steps to Plan an Event</li><li>Module 06: Invitation to the Event</li><li>Module 07: Event Marketing</li><li>Module 08: Catering at Events</li><li>Module 09: Event Decorations</li><li>Module 10: Cleaning and Waste Disposal</li><li>Module 11: Event Security</li><li>Module 12: Developing an Event Planning Business</li></ul> Course 02: Event Management <ul> <li>Event Planning</li><li>Steps for Planning an Event</li><li>Invitations, Greetings, and Dress Code</li><li>Table Manners and Table Settings</li><li>The Event</li><li>What is Event Management</li><li>Types of Events</li></ul> Course 03: Catering Management <ul> <li>Module 1: An Overview of Catering Business</li><li>Module 2: Laws and Legislations Regarding food Safety and Hygiene</li><li>Module 3: Food Safety and Hygiene</li><li>Module 4: Food Safety in Catering</li><li>Module 5: Management of Food and Beverage Operations</li><li>Module 6: Marketing and Human Resource</li></ul> Course 04: Business Analysis Level 3 <ul> <li>Module 01: Introduction to Business Analysis</li><li>Module 02: Business Processes</li><li>Module 03: Business Analysis Planning and Monitoring</li><li>Module 04: Strategic Analysis and Product Scope</li><li>Module 05: Solution Evaluation</li><li>Module 06: Investigation Techniques</li><li>Module 07: Ratio Analysis</li><li>Module 08: Stakeholder Analysis and Management</li><li>Module 09: Process Improvement with Gap Analysis</li><li>Module 10: Documenting and Managing Requirements</li><li>Module 11: Career Prospect as a Business Analyst in the UK</li></ul> Course 05: Interior Design Professional Diploma <ul> <li>Module 1: Introduction to Interior Design</li><li>Module 2: Design Principles</li><li>Module 3: Project Overview</li><li>Module 4: Design Elements</li><li>Module 5: Design Elements Practical Components</li><li>Module 6: Room by Room Design</li><li>Module 7: Popular Interior Designs</li><li>Module 8: Sustainable Design</li><li>Module 9: Presenting Your Ideas</li><li>Module 10: Managing Interior Design Business</li></ul> Course 06: Effective Communication Skills <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> Course 07: Basic Adobe Photoshop <ul> <li>Section 01: Shortcuts &amp; the Brush</li><li>Section 02: Layers</li><li>Section 03: Modify Your Portrait</li><li>Section 04: Watermark &amp; Figures</li><li>Section 05: Modify Your Text</li></ul> Course 08: Professional Photography Diploma <ul> <li>Introduction</li><li>Exposure</li><li>Digital Photography Masterclass</li><li>Focus and Depth of Field</li><li>Camera Anatomy</li><li>White Balance and Color</li><li>Lighting</li><li>Mobile Photography</li><li>Equipment - Cameras</li><li>Equipment - Lenses</li><li>Equipment - Accessories</li><li>Photo Scenario - Portrait</li><li>Photo Scenario - Long Exposure</li><li>Photo Scenario - Landscape</li><li>Photo Scenario - Product</li><li>Photo Scenario - Low Light</li><li>Photo Scenario - Sports &amp; Action</li><li>Photo Scenario - Macro</li><li>Photo Scenario - Street &amp; Architecture</li><li>Photo Scenario - Events</li><li>Photo Scenario - Aerial</li><li>Photo Scenario - Night</li><li>Intro to Photo Editing</li><li>Photoshop CC</li><li>Lightroom Classic CC</li><li>Lightroom CC</li><li>Mac Photos</li><li>Google Photos</li><li>Photoshop Express</li><li>Snapseed</li><li>Sharing Your Photos</li><li>Starting a Photo Business</li><li>Selling Stock Photos</li><li>Printing</li><li>Wildlife</li><li>Conclusion</li></ul> Course 09: Customer Relationship Management <ul> <li>Module 01: Introduction to Customer Relationship Management (CRM)</li><li>Module 02: CRM Fundamentals</li><li>Module 03: CRM Strategies CRM Strategies</li><li>Module 04: Data Analysis in CRM</li><li>Module 05: CRM Databases</li><li>Module 06: Deepening Customer Relationship</li><li>Module 07: Handling Customer Complaints</li><li>Module 08: Future of CRM</li></ul> Course 10: Baking and Cake Decorating Level 2 <ul> <li>Module 01: Sophisticated Baking &amp; Cake Design</li><li>Module 02: Icing</li><li>Module 03: Fondant Making</li><li>Module 04: Decorating with Fondant</li><li>Module 05: Everything in Brief</li></ul> Course 11: Health and Safety at Workplace <ul> <li>Module 01: Health and Safety at Work and the Laws</li><li>Module 02: Managing for Health and Safety</li><li>Module 03: Risk Assessment and Common Risks</li><li>Module 04: Workplace Health, Safety and Welfare</li><li>Module 05: Accidents and Ill Health at Work</li><li>Module 06: Electrical, Fire and Gas Safety</li><li>Module 07: Safety in Different Work Settings</li><li>Module 08: Work Equipment Hazards and Risk Control</li><li>Module 09: Other Health and Safety Hazards at Work</li></ul> How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. <ul> <li>PDF Certificate: Free (Previously it was £10 * 11 = £110)</li><li>Hard Copy Certificate: Free (For The Title Course)</li></ul> If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99.<h2>
 
 <div>CPD</div>
 </h2>

 <div id="cpd">
 <div>
 <div>
 <div>
 120 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">
 There is no experience or previous certifications required for enrolment on this bundle. It is available to all students, of all academic backgrounds. 
 </div><h2>
 
 <div>Requirements</div>
 </h2>

 <div id="requirements">
 Our bundle 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. There is no time limit for completing this course, it can be studied in your own time at your own pace. 
 </div><h2>
 
 <div>Career path</div>
 </h2>

 <div id="career_path">
 Having these various CPD certificate 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. 
 </div><h2>
 
 <div>Certificates</div>
 </h2>

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

 </div>

Apex Learning

Event Planner - CPD Accredited

11 in 1 "Family and Relationships Counselling" Bundle only at £53 Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Family and Relationships Counselling bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Family and Relationships Counselling bundle will help you stay ahead of the pack. Throughout the Family and Relationships Counselling programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Bundle Consists of the following Premium courses: <ul> <li> Course 01: Family Counsellor</li><li> Course 02: Couples Therapy &amp; Counselling</li><li> Course 03: Family Law 2021</li><li> Course 04: Family Support Worker Diploma</li><li> Course 05: Social Work Studies Diploma</li><li> Course 06: Safeguarding Children Level 3</li><li> Course 07: Domestic Violence and Abuse Awareness - Level 2</li><li> Course 08: Anti Social Behaviour</li><li> Course 09: Positive Psychology Masterclass</li><li> Course 10: EFT - Emotional Freedom Technique</li><li> Course 11: Equality and Diversity</li></ul> As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the course to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. Enrol now, to advance your career, and use the premium study materials from Apex Learning. Benefits you'll get from choosing Apex Learning for this Family and Relationships Counselling: <ul> <li>Pay once and get lifetime access to 11 CPD courses from this Course</li><li>Free e-Learning App for engaging reading materials &amp; helpful assistance</li><li>Certificates, student ID for the 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 from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li><li>Gain valuable knowledge of Family and Relationships Counselling without leaving your home</li></ul> How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. <ul> <li>PDF Certificate: Free (Previously it was £6*11 = £66)</li><li>Hard Copy Certificate: Free (For The Title Course: Previously it was £10)</li></ul>In this part, we'll discuss the course modules in detail so that you get a clear view of what your Family and Relationships Counselling learning journey would be. The course modules are divided into small sections for a better learning experience. Curriculum of the Bundle Course 01: Family Counsellor <ul> <li>Module 01 : Counselling and Counsellors</li><li>Module 02 : Theories and Models (Part 1)</li><li>Module 03 : Theories and Models (Part 2)</li><li>Module 04 : Legal, Cultural and Ethical Issues in Professional Counselling</li><li>Module 05 : Forms of Psychotherapy</li><li>Module 06 : Couple and Family Counselling</li><li>Module 07 : Trauma and Substance Abuse</li><li>Module 08 : Stress and Anxiety Disorders</li><li>Module 09 : Personality Disorders</li><li>Module 10 : Mood Disorders and Depression</li><li>Module 11 : Eating &amp; Sleeping Disorders</li><li>Module 12 : Self-Harm and Suicide</li><li>Module 13 : Communication Skills and Empathy</li></ul> Course 02: Couples Therapy &amp; Counselling <ul> <li>Module 01: Introduction</li><li>Module 02: Communication</li><li>Module 03: Conflict Resolution</li><li>Module 04: Intimacy</li><li>Module 05: Pre-Marital Counselling</li><li>Module 06: Healthy Fighting</li><li>Module 07: Affairs</li><li>Module 08: Apology &amp; Forgiveness</li><li>Module 09: Adapting to Changes</li><li>Module 10: Moving Forward Together</li></ul> Course 03: Family Law 2021 <ul> <li>Module 01: Introduction to Family Law</li><li>Module 02: Framing Family Law</li><li>Module 03: Marriage in Family Law</li><li>Module 04: Civil Partnership and Cohabitation</li><li>Module 05: Nullity in Marriage</li><li>Module 06: Divorce and Family Law</li><li>Module 07: Child Custody</li><li>Module 08: Property and Finance on Divorce</li><li>Module 09: Child Support and Family Law</li><li>Module 10: Adoption Process</li><li>Module 11: Domestic Violence</li><li>Module 12: Gender Equality in Family Law</li><li>Module 13: Feminist Perspectives on Family Law</li></ul> Course 04: Family Support Worker Diploma <ul> <li>Module 01: Introduction to Family Support Work</li><li>Module 02: Legislation, Policy and Guidance</li><li>Module 03: Solving Family Issues - Part 1</li><li>Module 04: Solving Family Issues - part 2</li><li>Module 05: Safeguarding - Assessing need and providing help (Part 1)</li><li>Module 06: Safeguarding - Assessing Need and Providing Help (Part 2)</li><li>Module 07: Building Relationships</li></ul> Course 05: Social Work Studies Diploma <ul> <li>Module 01: An Overview of Social Work</li><li>Module 02: Social Work Basics</li><li>Module 03: Theories of Social Work and Sociology</li><li>Module 04: Casework Process and Teamwork</li><li>Module 05: Dimensions of Social Work / Models of Intervention</li><li>Module 06: Practice Contexts and Application</li><li>Module 07: Working with Adults</li><li>Module 08: Principles of Conduct and Role as Social Care Worker</li></ul> Course 06: Safeguarding Children Level 3 <ul> <li>Module 01: Laws and Guidance</li><li>Module 02: Social and Emotional Development</li><li>Module 03: Personality and Intellectual Development of Children</li><li>Module 04: Child Abuse</li><li>Module 05: Sexual Abuse</li><li>Module 06: The Impact of Domestic Violence and Abuse on Children</li><li>Module 07: Risks and Risk Assessment</li><li>Module 08: Responding to Disclosure and Reporting</li><li>Module 09: Things to Do after Referral</li><li>Module 10: Safeguarding Trafficked Children</li><li>Module 11: Infant Mental Health and Early Attachment</li><li>Module 12: Assessing Need and Providing Early Help</li></ul> Course 07: Domestic Violence and Abuse Awareness - Level 2 <ul> <li>Module 01: Introduction to Domestic Violence &amp; Abuse</li><li>Module 02: The Components of Domestic Violence</li><li>Module 03: The Impact of Domestic Violence on Victims</li><li>Module 04: The Impact of Domestic Violence and Abuse on Children</li><li>Module 05: Assessing the Risks of Domestic Violence and Abuses on Children</li><li>Module 06: Supporting the Victim and Reporting Incidents</li><li>Module 07: Record Keeping</li><li>Module 8: Domestic Violence and Abuse Legislation in the UK</li></ul> Course 08: Anti Social Behaviour <ul> <li>Module 01: Overview of Anti-social Behaviour</li><li>Module 02: Family Influences on Anti-social Behaviour</li><li>Module 03: Anti-Social Behaviour Order</li><li>Module 04: Anger and Anti-social Behaviour</li><li>Module 05: Understanding Antisocial Personality</li><li>Module 06: Prevention of Anti-social Behaviour</li></ul> Course 09: Positive Psychology Masterclass <ul> <li>Section 01: Turn Negativity into Positivity</li><li>Section 02: Turn Anxiety &amp; Frustrations into Positivity</li><li>Section 03: Turn Surviving Into Thriving</li><li>Section 04: Create a Positive Mental Aptitude</li><li>Section 05: Master the Top Six Positivity Traits</li><li>Section 06: Turn Adversity into Resilience</li><li>Section 07: Master Your Grit Scale</li><li>Section 08: Turn Physical Dexterity into Positive Psychology</li><li>Section 09: Set Positive Boundaries</li><li>Section 10: Become More Genuine and Authentic</li><li>Section 11: Live Out Giving First</li><li>Section 12: Detach Yourself from the End Result</li></ul> Course 10: EFT - Emotional Freedom Technique <ul> <li>Module 01: What Is EFT (Emotional Freedom Technique)?</li><li>Module 02: EFT and Emotions, The Brain (EFT with the body)</li><li>Module 03: EFT Procedure</li><li>Module 04: Detailed Instructions of EFT</li><li>Module 05: Applying EFT to Physical Issues</li><li>Module 06: Treating Children with EFT</li><li>Module 07: EFT That Can Improve/ Heal Life &amp; Tips</li><li>Module 08: Doing Business with EFT</li></ul> Course 11: Equality and Diversity <ul> <li>Module 01: Introduction to Equality, Diversity and Discrimination</li><li>Module 02: Equality and Diversity Legislation</li><li>Module 03: Integrating Equality and Diversity into Policy</li><li>Module 04: Human Rights</li><li>Module 05: Promoting Diversity and Social Inclusion</li><li>Module 06: Equality Analysis</li><li>Module 07: Links between Values, Attitudes and Beliefs</li><li>Module 08: Basics of Discrimination</li><li>Module 09: Stereotypes, Prejudice, Discrimination and Bias</li><li>Module 10: Institutional Discrimination</li><li>Module 11: Unconscious Bias</li><li>Module 12: Affirmative Action</li><li>Module 13: Monitoring Equality and Diversity</li></ul><h2>
 
 <div>CPD</div>
 </h2>

 <div id="cpd">
 <div>
 <div>
 <div>
 110 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">
 Anyone from any background can enrol in this Family and Relationships Counselling bundle. 
 </div><h2>
 
 <div>Requirements</div>
 </h2>

 <div id="requirements">
 This course has been designed to be fully compatible with tablets and smartphones. 
 </div><h2>
 
 <div>Career path</div>
 </h2>

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

 <div id="optional_extras">
 <h4>Certificate of completion</h4>
 
 Digital certificate -
 Included
 
 <h4>Certificate of completion</h4>
 
 Hard copy certificate -
 Included
 
 <div> You will get the Hard Copy certificate for the title course (Family Counsellor) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. </div>

 </div>

Family and Relationships Counselling

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol NowWith a single payment you will gain access to Psychological Wellbeing Practitioner - Level 2 including 10 Career development courses, original hardcopy certificate, transcript and a student ID card.In this Psychological Wellbeing Practitioner - Level 2 course, you'll explore the Mental Capacity Act, the definition of psychological well-being and various approaches for promoting mental stability. You'll be able to measure the mental capacity of people suffering from ill mental health and assist them through their rehabilitation using positive psychology techniques.Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential.Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd.This course has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows.All of our courses have interactive online modules that allow studying to take place where and when you want it to.The only thing you need to take Psychological Wellbeing Practitioner - Level 2 is Wi-Fi and a screen. You'll never be late for class again.Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes.Benefits you'll get choosing Apex Learning for this Psychological Wellbeing Practitioner - Level 2:<ul><li>One payment, but lifetime access to 11 CPD courses</li><li>Certificates, student ID for the title course included in a one-time fee</li><li>Full tutor support available from Monday to Friday</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules taught 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><li>Gain valuable knowledge without leaving your home</li></ul>What other courses are included with this Psychological Wellbeing Practitioner - Level 2?<ul><li>Course 1: Level 2 Mindfulness for Wellbeing </li><li>Course 2: Emotional Intelligence and Human Behaviour </li><li>Course 3: Counselling Course </li><li>Course 4: Level 3 Mental Health Awareness Course </li><li>Course 5: Dialectal Behaviour Therapy (DBT) </li><li>Course 6: Domestic Violence and Abuse Awareness - Level 2 </li><li>Course 7: Adverse Childhood Experiences and Cure </li><li>Course 8: Addiction and Mental Health - Dual Diagnosis </li><li>Course 9: Rational Emotive Behaviour Therapy</li><li>Course 10: Covid 19 Psychological Impact and Wellbeing in Young People</li></ul>CurriculumCourse 1: Psychological Wellbeing Practitioner - Level 2 <ul><li>Module-1: Introduction to Psychotherapy</li><li>Module-2: Skills of a Psychological Wellbeing Practitioner</li><li>Module-3: Types of Therapies</li><li>Module-4: Engaging and Assessing the Patients</li><li>Module-5: Low Intensity CBT Treatment</li><li>Module-6: Forms of Psychotherapy</li><li>Module-7: Helping the Client in Crisis</li><li>Module-8: Crisis Intervention</li></ul>Course 2: Level 2 Mindfulness for Wellbeing<ul><li>Introduction &amp; First Concepts</li><li>Understanding &amp; Beating Anxiety</li><li>More Anti-Anxiety Skills &amp; Concepts</li><li>Conclusion</li></ul>Course 3: Emotional Intelligence and Human Behaviour <ul><li>Module 01: Human Behaviour and Basic Psychological Process</li><li>Module 02: Evolutionary Perspective of Human Behaviour</li><li>Module 03: Human Intelligence</li><li>Module 04: Intelligence Test and Variations in Intelligence</li><li>Module 05: Learning and Conditioning</li><li>Module 06: Language and Communication</li><li>Module 07: Introduction to Emotion</li><li>Module 08: Emotion Influences Cognition</li><li>Module 09: Stress, Anger and Conflict</li><li>Module 10: Emotional Intelligence</li><li>Module 11: Self-Leadership</li><li>Module 12: Neuro-Linguistic Programming (NLP)</li></ul>Course 4: Counselling Course <ul><li>Introduction to the course</li><li>Understanding Psychotherapy</li><li>Starting Psychotherapy Practice</li><li>Your Potential Clients in Therapy</li><li>Different Types of Psychotherapy</li><li>Internet Based Therapy</li></ul>Course 5: Level 3 Mental Health Awareness Course <ul><li>Module 1: Introduction to Mental Health</li><li>Module 2: Childhood And Adolescent Psychiatric Disorders</li><li>Module 3: Stress and Anxiety Disorders</li><li>Module 4: Schizophrenia</li><li>Module 5: Personality Disorders</li><li>Module 6: Mood Disorders</li><li>Module 7: Eating and Sleeping Disorders</li><li>Module 8: Self-Harm and Suicide</li><li>Module 9: Medication and Therapy in the Treatment of Mental Illness</li><li>Module 10: Social Attitudes To Mental Illness</li><li>Module 11: Mental Health Legislation and Services</li><li>Module 12: Mental Health In The Workplace</li></ul>Course 6: Dialectal Behaviour Therapy (DBT) <ul><li>Introduction</li><li>Introduction What is Counselling &amp; Psychotherapy</li><li>About Dialectical Behaviour Therapy (DBT)</li><li>DBT Strategies &amp; 'Life Skills'</li><li>Treatment by DBT</li><li>Effectiveness of DBT</li></ul>Course 7: Domestic Violence and Abuse Awareness - Level 2 <ul><li>Module 01: Introduction to Domestic Violence &amp; Abuse</li><li>Module 02: The Components of Domestic Violence</li><li>Module 03: The Impact of Domestic Violence on Victims</li><li>Module 04: The Impact of Domestic Violence and Abuse on Children</li><li>Module 05: Assessing the Risks of Domestic Violence and Abuses on Children</li><li>Module 06: Supporting the Victim and Reporting Incidents</li><li>Module 07: Record Keeping</li></ul>Course 8: Adverse Childhood Experiences and Cure <ul><li>Module 01: Introduction to Child Psychology</li><li>Module 02: Attachment and Relationship Building in Childhood</li><li>Module 03: Impacts of Separation and Loss on Attachment</li><li>Module 04: Factors That Influence Development</li><li>Module 05: Cognitive Development</li><li>Module 06: Social and Emotional Development</li><li>Module 07: Personality and Intellectual Development of Children</li><li>Module 08: Stages of Language Development</li><li>Module 09: Understanding Moral Development</li><li>Module 10: Play, Imagination, and Creativity</li><li>Module 11: Problems of Infancy</li><li>Module 12: Problems of Childhood</li><li>Module 13: Problems of Adolescence</li></ul>Course 9: Addiction and Mental Health - Dual Diagnosis <ul><li>SAMHI Dual Diagnosis Intro video</li><li>Module 01 - Drugs and Effects</li><li>Module 02 - Addictions &amp; Mental Health</li><li>Module 03 - Harm Minimisation &amp; Optimal Health</li><li>Module 04 - Brain Works - Neurophysiology</li><li>Module 05 - Trauma Model &amp; Keys to Treatment</li><li>Module 06 - Brief &amp; Early Intervention and Tripod of Support</li></ul>Course 10: Rational Emotive Behaviour Therapy<ul><li>Unit 01: Introduction</li><li>Unit 02: Foundations of REBT</li><li>Unit 03: REBT Techniques and Step-by-Step Practical Application</li><li>Unit 04: REBT in Special Conditions</li></ul>Course 10: Covid 19 Psychological Impact and Wellbeing in Young People<ul><li>Module 01. Anxiety and It's Causes</li><li>Module 02. Anxiety Disorders</li><li>Module 03. Anxiety in Children</li><li>Module 04. Anxiety in Young People</li><li>Module 05. Impact of Covid 19 on Children and Women and Young People</li><li>Module 06. Supporting Children During Covid 19</li><li>Module 07. Supporting Young People During Covid 19</li><li>Module 08. Managing Anxiety in Families with Children and Youth During the COVID-19 Outbreak</li><li>Module 09. Treatment of Anxiety Disorder</li><li>Module 10. Bereavement Guide During COVID 19</li></ul>How will I get my Certificate?After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.<ul><li>PDF Certificate: Free (Previously it was £6*11 = £66)</li><li>Hard Copy Certificate: Free (For The Title Course: Previously it was £10)</li></ul>If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10!P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99.<h2>
 
 <div>CPD</div>
 </h2>

 <div id="cpd">
 <div>
 <div>
 <div>
 115 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">
 There is no experience or previous qualifications required for enrolment on this Psychological Wellbeing Practitioner - Level 2. It is available to all students, of all academic backgrounds.** Completing this course does not imply that you are qualified to work as a Psychological Wellbeing Practitioner. If you are seeking a course that fits the HCPC's standards, please contact the HCPC or the RCSLT **
 </div><h2>
 
 <div>Requirements</div>
 </h2>

 <div id="requirements">
 Our Psychological Wellbeing Practitioner - Level 2 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.There is no time limit for completing this course, it can be studied in your own time at your own pace.
 </div><h2>
 
 <div>Career path</div>
 </h2>

 <div id="career_path">
 Having these various skills 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.
 </div><h2>
 
 <div>Certificates</div>
 </h2>

 <div id="optional_extras">
 <h4>Certificate of completion</h4>
 
 Digital certificate -
 Included
 
 <h4>Certificate of completion</h4>
 
 Hard copy certificate -
 Included
 
 <div> You will get the Hard Copy certificate for the title course (Psychological Wellbeing Practitioner - Level 2) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. </div>

 </div>

Psychological Wellbeing Practitioner - Level 2

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol NowProve that you are committed to Social Care and Community Welfare by training for your mandatory Care Certificate.This course provides all the principles, knowledge, and skills that you will need to absorb, to carry out exemplary Social Care.The Care Certificate in Child Development, Psychology, and Protection course has been written with the help of industry professionals and lays out all of the EU/UK standards for delivering care to the community. You will be taught how to safeguard the vulnerable, provide appropriate nutrition, respect privacy, and dignity, support those with challenges and disabilities, and ensure hygiene and cleanliness. Understand your responsibilities in the Social Sector today.Along with this Course you will get 10 additional premium courses, original hardcopy certificate, transcript and a student ID card.What other courses are included in this Bundle?<ul><li>Course 1: Care Certificate in Child Development, Psychology and Protection</li><li>Course 1: EYFS Teaching - Level 3</li><li>Course 2: Paediatric First Aid Level 3</li><li>Course 3: SEN Teaching Assistant and Child Development - Complete Bundle</li><li>Course 4: Play Therapy</li><li>Course 5: Safeguarding Children Level 3</li><li>Course 6: Learning Disability Awareness</li><li>Course 7: Home Based Childcare Course - Level 3</li><li>Course 8: Domestic Violence and Abuse Awareness - Level 2</li><li>Course 9: Counselling Course</li><li>Course 10: Coronavirus (COVID-19) Awareness</li></ul>Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential.Care Certificate in Child Development, Psychology and Protection will provide you with the CPD certificate that you'll need to succeed.Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd.Care Certificate in Child Development, Psychology and Protection has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows.All of our courses have interactive online modules that allow studying to take place where and when you want it to.The only thing you need to take Care Certificate in Child Development, Psychology and Protection is Wi-Fi and a screen. You'll never be late for class again.Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes.Benefits you'll get choosing Apex Learning:<ul><li>One payment, but lifetime access to 11 CPD courses</li><li>Certificates, student ID for the title course included in a one-time fee</li><li>Full tutor support available from Monday to Friday</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules taught 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><li>Gain valuable knowledge without leaving your home</li></ul>Course Curriculum***Care Certificate in Child Development, Psychology and Protection***<ul><li>Care Certificate in Child Development, Psychology and Protection</li><li>Childcare and Nutrition</li><li>Child Psychology</li><li>Safeguarding Children and Vulnerable Adults</li></ul>***EYFS Teaching - Level 3***<ul><li>Module 01: Introduction to EYFS</li><li>Module 02: Importance of Early Years in Development</li><li>Module 03: EYFS Teaching Techniques</li><li>Module 04: Working as an EYFS Teacher</li><li>Module 05: Promoting Learning and Development</li><li>Module 06: Children Having Special Education Needs or Disabilities</li><li>Module 07: Parents' Guide to the Early Years Foundation Stage</li><li>Module 08: Welfare Requirements</li><li>Module 09: The EYFS Educational Philosophies and Privileges</li><li>Module 10: Registration, Inspection, and Quality Improvement</li><li>Module 11: EYFS Framework in 2021</li></ul>***Paediatric First Aid Level 3***<ul><li>Module 01: Aim of First Aid and the First Steps</li><li>Module 02: Resuscitation (CPR)</li><li>Module 03: Secondary Assessment, The Recovery Position And Shock</li><li>Module 04: Head and Eye Injuries, Fractures, and Amputation</li><li>Module 05: Choking, Wounds, Bleeding &amp; Burns</li><li>Module 06: Secondary Conditions and Reactions I</li><li>Module 07: Secondary Conditions and Reactions II</li><li>Module 08: Chronic Conditions</li><li>Module 09: Medical Emergencies - Poisoning, Smoke inhalation, Hypothermia, Elect</li></ul>***SEN Teaching Assistant and Child Development - Complete Bundle***<ul><li>Module 01: Special Education Needs (SEN) An Overview</li><li>Module 02: SEN Support</li><li>Module 03: High Quality Teaching for Pupils with SEN</li><li>Module 04: SEN Teaching Methodologies</li><li>Module 05: Communication and Interaction</li><li>Module 06: Cognition and Learning</li><li>Module 07: Social, Emotional and Mental Health Difficulties</li><li>Module 08: Sensory or Physical Needs</li><li>Module 09: Working in Partnership</li></ul>***Play Therapy***<ul><li>Module 01: What is Play Therapy</li><li>Module 02: Advantages and Outcomes of Play Therapy</li><li>Module 03: Models and Approaches of Play Therapy</li><li>Module 04: The Play Settings: Therapist, Abused Child and Materials</li><li>Module 05: Typical Issues in Play Therapy</li><li>Module 06: Play Therapy for Sexually and Emotionally Abused Children</li><li>Module 07: Play Therapy for Children Who are Homeless</li><li>Module 08: Play Interventions for Disaster Mental Health</li><li>Module 09: Case Studies and Recent Trends in Play Therapy</li></ul>***Safeguarding Children Level 3***<ul><li>Module 01: Laws and Guidance</li><li>Module 02: Social and Emotional Development</li><li>Module 03: Personality and Intellectual Development of Children</li><li>Module 04: Child Abuse</li><li>Module 05: Sexual Abuse</li><li>Module 06: The Impact of Domestic Violence and Abuse on Children</li><li>Module 07: Risks and Risk Assessment</li><li>Module 08: Responding to Disclosure and Reporting</li><li>Module 09: Things to Do after Referral</li><li>Module 10: Safeguarding Trafficked Children</li><li>Module 11: Infant Mental Health and Early Attachment</li><li>Module 12: Assessing Need and Providing Early Help</li></ul>***Learning Disability Awareness***<ul><li>Module 01: Learning Disability and Mental Health</li><li>Module 02: Learning Disability Nursing</li><li>Module 03: Psychosocial Interventions</li><li>Module 04: Psychodynamic Approaches</li><li>Module 05: Learning Disability Nursing Throughout the Lifespan</li><li>Module 06: Role of the Learning Disability Nurse in Promoting Health and Well-Being</li><li>Module 07: Care Planning in Mental Health Settings</li><li>Module 08: Nursing Models and Behavioural Interventions</li><li>Module 09: The Future of Learning Disability Nursing</li><li>Module 10: Future Spheres of Practice for Learning Disability Nursing</li></ul>***Home Based Childcare Course - Level 3***<ul><li>Module 01: Introduction to Home-Based Childcare</li><li>Module 02: Registering as an Approved Home-Based Childcarer</li><li>Module 03: Effective Skills of a Childcarer</li><li>Module 04: Children's Learning and Development</li><li>Module 05: Safeguarding Children</li><li>Module 06: Health and Safety</li><li>Module 07: Healthy Food for Children</li><li>Module 08: Children with Special Needs</li><li>Module 09: Law and Legislation</li></ul>***Domestic Violence and Abuse Awareness - Level 2***<ul><li>Module 01: Introduction to Domestic Violence &amp; Abuse</li><li>Module 02: The Components of Domestic Violence</li><li>Module 03: The Impact of Domestic Violence on Victims</li><li>Module 04: The Impact of Domestic Violence and Abuse on Children</li><li>Module 05: Assessing the Risks of Domestic Violence and Abuses on Children</li><li>Module 06: Supporting the Victim and Reporting Incidents</li><li>Module 07: Record Keeping</li></ul>***Counselling Course***<ul><li>Introduction to the course</li><li>Understanding Psychotherapy</li><li>Starting Psychotherapy Practice</li><li>Your Potential Clients in Therapy</li><li>Different Types of Psychotherapy</li><li>Internet Based Therapy</li></ul>***Coronavirus (COVID-19) Awareness***<ul><li>Introduction to COVID-19</li><li>Understanding of Covid-19 as a Pandemic and How It Is Related to Zoonotic Diseases Like SARS and MERS</li><li>The Strike of Pandemic Around the World and Great Britain</li><li>Effects of Covid-19 on Human Life</li><li>Diagnosis and Treatment</li><li>Preventions and Social Measures to Be Taken</li><li>Artificial Intelligence, Data Science and Technological Solutions against Covid-19</li></ul>How will I get my Certificate?After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.<ul><li>PDF Certificate: Free (Previously it was £10 * 11 = £110)</li><li>Hard Copy Certificate: Free (For The Title Course)</li></ul>P.S. The delivery inside the U.K. is Free. International students have to pay a £3.99 postal charge.<h2>
 
 <div>CPD</div>
 </h2>

 <div id="cpd">
 <div>
 <div>
 <div>
 115 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">
 There is no experience or previous qualifications required for enrolment on this Care Certificate in Child Development, Psychology and Protection. It is available to all students, of all academic backgrounds.** Completing this course does not imply that you are qualified to work as a Practitioner Psychologist. If you are seeking a course that fits the HCPC's standards, please contact the HCPC or the RCSLT. **
 </div><h2>
 
 <div>Requirements</div>
 </h2>

 <div id="requirements">
 Our course 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.There is no time limit for completing this course, it can be studied in your own time at your own pace.
 </div><h2>
 
 <div>Career path</div>
 </h2>

 <div id="career_path">
 Having these various CPD certificate 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.
 </div><h2>
 
 <div>Certificates</div>
 </h2>

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

 </div>

Care Certificate in Child Development, Psychology and Protection

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment you will gain access to Health and Safety Executive including 10 additional premium courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Courses are included with this Health and Safety Executive Complete Bundle: <ul> <li>Course 01: Health and Safety Executive</li><li>Course 02: LOLER Training</li><li>Course 03: Asbestos Awareness Level 2</li><li>Course 04: RIDDOR Training</li><li>Course 05: Fire Safety Awareness Level 2</li><li>Course 06: COSHH Awareness Level 3</li><li>Course 07: Manual Handling Level 2</li><li>Course 08: Mental Health First Aid</li><li>Course 09: First Aid at Work</li><li>Course 10: Biohacking Your Physical and Mental Health</li><li>Course 11: Personal Hygiene</li></ul> If you want to gain a solid understanding of Health and Safety Executive and fast track your dream career, then take a step in the right direction with this industry-standard, comprehensive Health and Safety Executive course designed by expert instructors. You'll have 24/7 online access to the study materials, introductory videos, assessment tests, study resources and tutor support for a lifetime. The Health and Safety Executive will help you to develop your skills, confidence and knowledge of this sector, helping to add real value to your CV and personal development. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Health and Safety Executive has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Health and Safety Executive is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Whether you are looking to brighten up your CV, just starting out in the industry, looking for a career change or just fancy learning something new, this online course is perfect! Benefits you'll get choosing Apex Learning: <ul> <li>One payment, but lifetime access to 11 CPD courses</li><li>Certificates, student ID for the title course included in a one-time fee</li><li>Full tutor support available from Monday to Friday</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules taught 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><li>Gain valuable knowledge without leaving your home</li></ul>Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Course Curriculum: <ul> <li>Module 01: Health and Safety at Work and the Laws</li><li>Module 02: Managing for Health and Safety</li><li>Module 03: Risk Assessment and Common Risks</li><li>Module 04: Workplace Health, Safety and Welfare</li><li>Module 05: Accidents and Ill Health at Work</li><li>Module 06: Electrical, Fire and Gas Safety</li><li>Module 07: Safety in Different Work Settings</li><li>Module 08: Work Equipment Hazards and Risk Control</li><li>Module 09: Other Health and Safety Hazards at Work</li></ul> Course 2: LOLER Training <ul> <li>Module 01: Introduction to LOLER</li><li>Module 02: Part 01 - Selecting Lifting Equipment and Accessories</li><li>Module 03: Part 02 - Selecting Lifting Equipment and Accessories</li><li>Module 04: Planning the Lifting Operation</li><li>Module 05: Factors Affecting Safe Lifting Operation</li><li>Module 06: Roles and Responsibilities</li><li>Module 07: Risk Assessment</li><li>Module 08: Examination and Inspection</li><li>Module 09: Reports and Defects</li></ul> Course 3: Asbestos Awareness Level 2 <ul> <li>Module 01: Asbestos Explained</li><li>Module 02: Asbestos Identified</li><li>Module 03: Asbestos and the Law</li><li>Module 04: Risk Factors of Asbestos</li><li>Module 05: Surveys and Risk Assessment</li><li>Module 06: Asbestos Awareness Safety</li><li>Module 07: Asbestos Containing Waste (ACW) Disposal</li><li>Module 08: Accidental Disturbance of ACMs and Dealing with Emergencies</li></ul> Course 4: RIDDOR Training <ul> <li>Module 1: Health and Safety at Work and the Laws</li><li>Module 2: Managing for Health and Safety</li><li>Module 3: Risk Assessment and Common Risks</li><li>Module 4: RIDDOR</li></ul> Course 5: Fire Safety Awareness Level 2 <ul> <li>Module 1: Introduction to Fire Safety</li><li>Module 2: Fire Safety Law</li><li>Module 3: Measures of Fire Safety</li><li>Module 4: Evacuation Procedures</li></ul> Course 6: COSHH Awareness Level 3 <ul> <li>Module 01: COSHH Explained</li><li>Module 02: COSHH Regulations</li><li>Module 03: Health Problems Related to Hazardous Substances</li><li>Module 04: Identifying Hazardous Substances</li><li>Module 05: COSHH Risk Assessments</li><li>Module 06: Control Measures and Monitoring</li><li>Module 07: Implementing Control Measures</li></ul> Course 7: Manual Handling Level 2 <ul> <li>Module 01: Introduction, Legislation and Guidance</li><li>Module 02: Manual Handling Hazards and Injuries</li><li>Module 03: Manual Handling Risk Assessments</li><li>Module 04: Controlling and Reducing the Risks</li><li>Module 05: Safe Lifting Techniques</li></ul> Course 8: Mental Health First Aid <ul> <li>Module 1: Introduction to Mental Health</li><li>Module 2: Overview of Mental Health First Aid</li><li>Module 3: Childhood and Adolescent Psychiatric Disorders</li><li>Module 4: Stress and Anxiety Disorders</li><li>Module 5: Schizophrenia</li><li>Module 6: Personality Disorders</li><li>Module 7: Mood Disorders</li><li>Module 8: Eating &amp; Sleeping Disorders</li><li>Module 9: Self-Harm and Suicide</li><li>Module 10: Medication and Therapy in the Treatment of Mental Illness</li><li>Module 11: Social Attitudes to Mental Illness</li><li>Module 12: Mental Health Legislation and Services</li><li>Module 13: Mental Health in the Workplace</li><li>Module 14: Approach and React To People in Mental Health Crisis</li></ul> Course 9: First Aid at Work <ul> <li>Module 01: Introduction to Workplace First Aid</li><li>Module 02: Legal Framework for Workplace First Aid</li><li>Module 03: Incident Management at Work</li><li>Module 04: Primary Survey</li><li>Module 05: Secondary Survey</li><li>Module 06: Basic First-Aid Techniques</li><li>Module 07: Dealing with Minor Injuries at Workplace</li><li>Module 08: Secondary Illness: Loss of Responsiveness and CPR</li><li>Module 09: Secondary Illness: Breathing Problems</li><li>Module 10: Secondary Illnesses and Injuries</li><li>Module 11: Dealing With Fractures and Dislocations</li><li>Module 12: Call for an Emergency</li></ul> Course 10: Biohacking Your Physical and Mental Health <ul> <li>Module 01: Introduction</li><li>Module 02: Sleep - So MUCH More Than Just Rest</li><li>Module 03: Blue Light &amp; Red Light</li><li>Module 04: Mindfulness &amp; Movement</li><li>Module 05: What You Put In Your Mouth is KEY!</li><li>Module 06: Hidden Secret - 'Cryotherapy'</li><li>Module 07: Importance Of PURE Air</li><li>Module 08: Final Thoughts &amp; Recommendations</li></ul> Course 11: Personal Hygiene <ul> <li>Module 01: Introduction to Personal Hygiene and a Brief History</li><li>Module 02: Looking Clean, Smelling Clean</li><li>Module 03: Improving and Maintaining Oral Health</li><li>Module 04: Care of the Eyes</li><li>Module 05: Ear Care Secrets</li><li>Module 06: Foot &amp; Nail Care in Personal Hygiene</li><li>Module 07: Hair Care Hygienic Ways</li><li>Module 08: Hygienic Approach to Skin Care</li><li>Module 09: Maintain Good Toilet Hygiene</li><li>Module 10: Potential Hygiene Guidelines</li><li>Module 11: Personal Hygiene During Coronavirus Pandemic</li></ul> How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. <ul> <li>PDF Certificate: Free (Previously it was £6*11 = £66)</li><li>Hard Copy Certificate: Free (For The Title Course: Previously it was £10)</li></ul> If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery inside the U.K. is Free. International students have to pay a £3.99 postal charge.<h2>
 
 <div>CPD</div>
 </h2>

 <div id="cpd">
 <div>
 <div>
 <div>
 110 CPD hours / points
 </div>
 <div>
 Accredited by CPD Quality Standards
 </div>
 </div>
 </div>
 </div><h2>
 
 <div>Requirements</div>
 </h2>

 <div id="requirements">
 There is no time limit for completing this course, it can be studied in your own time at your own pace 
 </div><h2>
 
 <div>Career path</div>
 </h2>

 <div id="career_path">
 Having these various CPD certificate 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. 
 </div><h2>
 
 <div>Certificates</div>
 </h2>

 <div id="optional_extras">
 <h4>Certificate of completion</h4>
 
 Digital certificate -
 Included
 
 <h4>Certificate of completion</h4>
 
 Hard copy certificate -
 Included
 
 <div> You will get the Hard Copy certificate for the title course (Health and Safety Executive) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. </div>

 </div>

Health & Safety Awareness

Health, Safety & Environment (HSE)

Health & Safety

Trainers Course

Health & Safety At Work

Health Sciences Courses (HSC)

Health and Safety Executive



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


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


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


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


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


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


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


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


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


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


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


For more information, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Professional Development

Continuous Professional Development (CPD)

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

Southend-On-Sea

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

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



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

Let’s Do Business Group

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

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

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

Financial Analysis

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

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

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



On this course, you will…

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


Who will benefit from this course:

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


Course Outline

Module 1: What is and why buy Real Estate?

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


Module 2: The Real Estate Market System

The Space Market
The Asset Market
The Development Market


Module 3: How to value Real Estate

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


Module 4: How to read a Real Estate Market Report

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


Module 5: Who works in Real Estate?

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


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

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

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

DG Legal

Anti-Money Laundering (AML)

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

General Delegate

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

Retainer Delegate

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

Nexus Human

Spreadsheet

Excel - Excel Essentials and Formulas

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

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

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

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





Compliance Officer For Finance and Administration (COFA) Masterclass Course

WelcomeHello and welcome to our 1-day Introduction to Coaching.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;&nbsp;Why Free?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;&nbsp;This day may be a good investment of your time if:<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>&nbsp;What does the day offer?&nbsp;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.&nbsp;During the day we will work through topics such as:<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>&nbsp;About Coaching Development:<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.&nbsp;Our promise to you:<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>&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;

Coaching Development Ltd

An ICF accredited coach training programme.

Coaching Development's FREE Introduction to Coaching Day

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

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)

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

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

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

This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses. On this course delegates will... &bull; Learn how to build senior debt models with geared net cash flow. &bull; Explore and assess the influence of complex debt structures on returns. &bull; Develop advanced mezzanine debt models affecting project cash flows. &bull; Model joint venture structures for optimised partnerships. &bull; Calculate promote and profit share structures in Real Estate transactions. &bull; Construct sophisticated project cash flow models with mezzanine debts. Who will benefit from this course? &bull; Real Estate Professionals who have had exposure to Real Estate financial models &bull; Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis &bull; Real Estate Developers &bull; Financial Analysts &bull; Investment Managers &bull; Banking and Finance Professionals in Real Estate Course Outline &bull; Mathematics of amortisation and debt finance. &bull; Basic senior debt models and geared net cash flow. &bull; Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics. &bull; Mezzanine debt modelling. &bull; Joint Venture structures between developers and lender/equity partners. &bull; Promote and profit share structure calculations. &bull; Advanced project cash flows with mezzanine debt. Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the Real Estate Finance such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



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

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

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

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


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


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

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

6404 Courses

Excel 365 Beginner

By iStudy UK

Accredited Diploma in Microsoft Excel 2007

By iStudy UK

Professional Diploma in Microsoft Excel 2010

By iStudy UK

Excel 365 Intermediate

By iStudy UK

Excel 2016 Advanced

By iStudy UK

Event Planner - CPD Accredited

By Apex Learning

Family and Relationships Counselling

By Apex Learning

Psychological Wellbeing Practitioner - Level 2

By Apex Learning

Care Certificate in Child Development, Psychology and Protection

By Apex Learning

Health and Safety Executive

By Apex Learning

Search By Location