Name: Microsoft Excel For Beginners
Price: 19 GBP
Availability: InStock

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

 

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

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

					
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Essential Formulas and Functions</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Mathematical Functions					</td>

					
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Textual Functions					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Logical Functions					</td>

					
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Date-time (Temporal) Functions					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Lookup Formulas</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Lookup Functions					</td>

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

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

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

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Charts</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Charts-Part 1					</td>

					
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Charts-Part 2					</td>

					
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td colspan="4">Named Ranges</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Named Ranges					</td>

					
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Indirect Functions					</td>

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

					
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td colspan="4">Analytics in Excel</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Analytics in Excel					</td>

					
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4">Macros</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Macros					</td>

					
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td colspan="4">Excel Uses Cases: Engaging Visualizations</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Infographics 1: Cool charts					</td>

					
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Infographics 2: Cool charts					</td>

					
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Waterfall chart					</td>

					
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td colspan="4">Excel Uses Cases: Modeling Customer Lifetime value</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Concept of Net Present Value and Customer Value					</td>

					
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Finding Net Present Value in Excel					</td>

					
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Sensitivity Analysis in Excel					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Variations in finding customer value					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Assessment</td>
				</tr>
								<tr>
					<td></td>
					<td>Assessment - Microsoft Excel For Business</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate of Achievement</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Certificate of Achievement					</td>

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

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

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

			</div>

Study Plex

Microsoft Excel For Business

General Admission

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

 

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

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

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Part 1: Forecasting</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Basics of Forecasting					</td>

					
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Creating Linear Model with Trendlines					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">1.1 Getting Data Ready For Regression Model</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Gathering Business Knowledge					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Data Exploration					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						The Data and the Data Dictionary					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Univariate analysis and EDD					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Discriptive Data Analytics in Excel					</td>

					
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Outlier Treatment					</td>

					
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Identifying and Treating Outliers in Excel					</td>

					
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Missing Value Imputation					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Identifying and Treating missing values in Excel					</td>

					
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Variable Transformation in Excel					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Dummy variable creation: Handling qualitative data					</td>

					
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Dummy Variable Creation in Excel					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Correlation Analysis					</td>

					
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Creating Correlation Matrix in Excel					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">1.2 Forecasting Using Regression Model</td>
				</tr>
								<tr>
					<td></td>
					<td>
						The Problem Statement					</td>

					
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Basic Equations and Ordinary Least Squares (OLS) method					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Assessing accuracy of predicted coefficients					</td>

					
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Assessing Model Accuracy: RSE and R squared					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Creating Simple Linear Regression model					</td>

					
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Multiple Linear Regression					</td>

					
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						The F - statistic					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Interpreting results of Categorical variables					</td>

					
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Creating Multiple Linear Regression model					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">1.3 Handling Special Events Like Holiday Sales</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Forecasting in presence of special events					</td>

					
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Excel: Running Linear Regression using Solver					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Excel: Including the impact of Special Events					</td>

					
					<td> </td>
					<td> 00:22:00</td>
				</tr>
								<tr>
					<td colspan="4">1.4 Identifying Seasonality &amp; Trend for Forecasting</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Models to identify Trend &amp; Seasonality					</td>

					
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Excel: Additive model to identify Trend &amp; Seasonality					</td>

					
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Excel: Multiplicative model to identify Trend &amp; Seasonality					</td>

					
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Market Basket Analysis</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Market Basket and Lift - Introduction					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Named Ranges - Excel					</td>

					
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Indirect Function - Excel					</td>

					
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						2-way lift calculation in Excel					</td>

					
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						2-way lift calculation - Dynamic					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						2-way lift data table creation					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						3-way lift calculation					</td>

					
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Store Layout optimization using Lift values					</td>

					
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4">RFM (Recency, Frequency, Monetary) Analysis</td>
				</tr>
								<tr>
					<td></td>
					<td>
						RFM (recency, frequency, monetary) Analysis					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						RFM Analysis in Excel- Part 1					</td>

					
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						RFM Analysis in Excel- Part 2					</td>

					
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td colspan="4">Part 2: Pricing</td>
				</tr>
								<tr>
					<td colspan="4">Part 2: Pricing</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Steps of setting a Pricing policy					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Different Pricing Objectives					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">2.1 Estimating Demand</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Estimating Demand					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Forms of Demand Curve					</td>

					
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Excel: Estimating Linear Demand Curve					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Excel: Estimating Power Demand curve with Elasticity					</td>

					
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Excel: Estimating Power Demand Curve with points					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Subjective Demand curve					</td>

					
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Excel: Estimating Subjective Demand Curve					</td>

					
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">2.3 Evaluating Pricing Strategies</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Price Bundling					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Types of Bundling					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						The Bundling Problem					</td>

					
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Excel: Solving Bundling problem Part 1					</td>

					
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Excel: Solving Bundling problem Part 2					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Non-Linear Pricing Strategies					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Excel: Solving Bundling problem (Price Reversal)					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">3.1 Lifetime Customer Value</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Lifetime Customer Value - Key concepts					</td>

					
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Lifetime Customer Value - Excel model					</td>

					
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td colspan="4">3.2 Variations And Sensitivity Analysis</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Sensitivity Analysis in Excel					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Variations in finding customer value					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Appendix 1: Excel Crash Course</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Basics					</td>

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

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

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

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

					
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Basic Formula Operations					</td>

					
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Mathematical Formulas					</td>

					
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Textual Formulas					</td>

					
					<td> </td>
					<td> 00:17:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Logical Formulas					</td>

					
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Date-Time Formulas					</td>

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

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Data Tools					</td>

					
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Formatting data and tables					</td>

					
					<td> </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Pivot Tables					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Advance Excel- Solver, Data tables					</td>

					
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4"> Assessment</td>
				</tr>
								<tr>
					<td></td>
					<td>Assessment - Retail Analytics In Microsoft Excel Diploma</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td colspan="4">Obtain Your Certificate</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Order Your Certificate of Achievement					</td>

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

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

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

			</div>

Retail Analytics In Microsoft Excel Diploma

<div> <div> </div> <div> <div> <div> <h3>Highlights of the Course</h3> <ul> <li>Course Type: Online Learning</li> <li>Duration: 1 Hour</li> <li>Tutor Support: Tutor support is included</li> <li>Customer Support: 24/7 customer support is available</li> <li>Quality Training: The course is designed by an industry expert</li> <li>Recognised Credential: Recognised and Valuable Certification</li> <li>Completion Certificate: Free Course Completion Certificate Included</li> <li>Instalment: 3 Installment Plan on checkout</li> </ul> </div> </div> <div> <div> <hr /> <h3>What you will learn from this course?</h3> <ul> <li>Gain comprehensive knowledge about Microsoft Office Excel</li> <li>Understand the core competencies and principles of Microsoft Office Excel</li> <li>Explore the various areas of Microsoft Office Excel</li> <li>Know how to apply the skills you acquired from this course in a real-life context</li> <li>Become a confident and expert office admin</li> </ul> </div> </div> <hr /> <div> <div> <div> <h3>Dynamic Arrays in Excel Program Course</h3> Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. </div> <div> <h3>Who is this Course for?</h3> This comprehensive Excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. </div> <div> <h3>Entry Requirements</h3> This Excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. </div> <div> <h3>Assessment</h3> This Excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. </div> <div> <h3>Advance Your Career</h3> This Excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. </div> </div> </div> </div> </div><h3>Recognised Accreditation</h3> This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement.<div> <h3> Course Curriculum </h3> <div> <table> <tbody><tr> <td colspan="4">Dynamic Arrays in Excel</td> </tr> <tr> <td></td> <td> Dynamic Arrays in Excel </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> XLOOKUP </td> <td> </td> <td> 00:09:00</td> </tr> <tr> <td></td> <td> FILTER and UNIQUE </td> <td> </td> <td> 00:19:00</td> </tr> <tr> <td></td> <td> SORT and SORTBY </td> <td> </td> <td> 00:12:00</td> </tr> <tr> <td></td> <td> SEQUENCE and RANDARRAY </td> <td> </td> <td> 00:13:00</td> </tr> <tr> <td colspan="4">Obtain Your Certificate</td> </tr> <tr> <td></td> <td> Order Your Certificate of Achievement </td> <td> </td> <td> 00:00:00</td> </tr> <tr> <td colspan="4">Get Your Insurance Now</td> </tr> <tr> <td></td> <td> Get Your Insurance Now </td> <td> </td> <td> 00:00:00</td> </tr> <tr> <td colspan="4">Feedback</td> </tr> <tr> <td></td> <td> Feedback </td> <td> </td> <td> 00:00:00</td> </tr> </tbody></table></div> </div>

Dynamic Arrays in Excel Program

<div> <div> </div> <div> <div> <div> <h3>Highlights of the Course</h3> <ul> <li>Course Type: Online Learning</li> <li>Duration: 2 Hours 5 Minutes</li> <li>Tutor Support: Tutor support is included</li> <li>Customer Support: 24/7 customer support is available</li> <li>Quality Training: The course is designed by an industry expert</li> <li>Recognised Credential: Recognised and Valuable Certification</li> <li>Completion Certificate: Free Course Completion Certificate Included</li> <li>Instalment: 3 Installment Plan on checkout</li> </ul> </div> </div> <div> <div> <hr /> <h3>What you will learn from this course?</h3> <ul> <li>Gain comprehensive knowledge about Microsoft Office Excel</li> <li>Understand the core competencies and principles of Microsoft Office Excel</li> <li>Explore the various areas of Microsoft Office Excel</li> <li>Know how to apply the skills you acquired from this course in a real-life context</li> <li>Become a confident and expert office admin</li> </ul> </div> </div> <div> <div> <div> <hr /> <div> <div> <div> <h3>Microsoft Office Excel 2016: Part 1 Beginner Level Course</h3> Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive excel beginner level course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel beginner level course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this excel beginner level course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. </div> <div> <h3>Who is this Course for?</h3> This comprehensive excel beginner level course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. </div> <div> <h3>Entry Requirements</h3> This excel beginner level course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. </div> <div> <h3>Assessment</h3> This excel beginner level course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. </div> <div> <h3>Advance Your Career</h3> This excel beginner level course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. </div> </div> </div> </div> </div> </div> </div> </div><h3>Recognised Accreditation</h3> This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement.<div> <h3> Course Curriculum </h3> <div> <table> <tbody><tr> <td colspan="4">Getting Started With Excel 2016</td> </tr> <tr> <td></td> <td> Navigate the Excel User Interface - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Navigate the Excel User Interface </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Use Excel Commands - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Use Excel Commands - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Create and Save a Basic Workbook - Introduction </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td></td> <td> Create and Save a Basic Workbook </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td></td> <td> Enter Cell Data - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Enter Cell Data </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td></td> <td> Flash Fill and Auto Fill </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td></td> <td> Use Excel Help - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Use Excel Help </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td colspan="4">Performing Calculations</td> </tr> <tr> <td></td> <td> Create Worksheet Formulas - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Create Worksheet Formulas </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Insert Functions - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Insert Functions </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td></td> <td> Reuse Formulas and Functions - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Reuse Formulas and Functions </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td colspan="4">Modifying a Worksheet</td> </tr> <tr> <td></td> <td> Insert, Delete and Adjust Cells, Columns and Rows </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td></td> <td> Search for and Replace Data </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Insert, Delete and Adjust Cells, Columns and Rows - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Use Proofing and Research Tools </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Check the Spelling in a Worksheet </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> Search for and Replace Data - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Insights Task Pane </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td colspan="4">Formatting a Worksheet</td> </tr> <tr> <td></td> <td> Apply Text Formats - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Apply Text Formats </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Apply Number Formats - Introduction </td> <td> </td> <td> 00:02:00</td> </tr> <tr> <td></td> <td> Apply Number Formats </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> Align Cell Contents - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Align Cell Contents </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> Apply Cell Styles and Themes </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Apply Cell Styles and Themes - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Create and Use Templates - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Apply Basic Conditional Formatting - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Apply Basic Conditional Formatting </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> Create and Use Templates </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td colspan="4">Printing Workbooks</td> </tr> <tr> <td></td> <td> Preview and Print a Workbook </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Configure and Preview a Print Job </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> Set Up the Page Layout - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Set Up the Page Layout </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td></td> <td> Configure Headers and Footers - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Configure Headers and Footers </td> <td> </td> <td> 00:02:00</td> </tr> <tr> <td colspan="4">Managing Workbooks</td> </tr> <tr> <td></td> <td> Manage Worksheets - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Manage Worksheets </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td></td> <td> Manage Workbook and Worksheet Views - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Manage Workbook and Worksheet Views </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Manage Workbook Properties - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Manage Workbook Properties </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td colspan="4">Final Assessment</td> </tr> <tr> <td></td> <td>Assessment - Microsoft Office Excel 2016: Part 1 Beginner Level</td> <td> </td> <td> 00:10:00</td> </tr> <tr> <td colspan="4">Obtain Your Certificate</td> </tr> <tr> <td></td> <td> Order Your Certificate of Achievement </td> <td> </td> <td> 00:00:00</td> </tr> <tr> <td colspan="4">Get Your Insurance Now</td> </tr> <tr> <td></td> <td> Get Your Insurance Now </td> <td> </td> <td> 00:00:00</td> </tr> <tr> <td colspan="4">Feedback</td> </tr> <tr> <td></td> <td> Feedback </td> <td> </td> <td> 00:00:00</td> </tr> </tbody></table></div> </div>

Microsoft Office Excel 2016: Part 1 Beginner Level Course

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

 

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

<div>
<table>				<tbody><tr>
					<td colspan="4"> Introduction and Basics Most important charts &amp; best Practices Pivot charts Less used charts Sparklines Infographics using Excel charts Appendix: Bonus Excel functionalities</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Welcome to the Course					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Why are charts used?					</td>

					
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Categories of messages that can be conveyed					</td>

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

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

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Most Important Charts &amp; Best Practices</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Bar and column charts					</td>

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

					
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Best Practices: Bar Chart					</td>

					
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Line Charts					</td>

					
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Avoiding the Spaghetti plot					</td>

					
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Area Charts					</td>

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

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

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

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

					
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Waterfall chart					</td>

					
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Hierarchy Charts: Sunburst and Treemap					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Combination charts					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Highlighting chart message					</td>

					
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Eliminating Distractions from the Graph					</td>

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Avoiding clutter					</td>

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

					
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Pivot Table Basics					</td>

					
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Less Used Charts</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Stock charts					</td>

					
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Radar charts					</td>

					
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Surface charts					</td>

					
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Heatmaps					</td>

					
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Sparklines</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Mini charts: Sparklines					</td>

					
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Infographics Using Excel Charts</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Creative Infographic 1					</td>

					
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Creative Infographic 2					</td>

					
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Appendix: Bonus Excel Functionalities</td>
				</tr>
								<tr>
					<td></td>
					<td>
						How to solve transportation problem using Excel Goal-Seek					</td>

					
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate of Achievement</td>
				</tr>
								<tr>
					<td></td>
					<td>
						Certificate of Achievement					</td>

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

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

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

			</div>

Microsoft Excel For Data Visualization

<div> <div> </div> <div> <div> <div> <h3>Highlights of the Course</h3> <ul> <li>Course Type: Online Learning</li> <li>Duration: 1 Hour 17 Minutes</li> <li>Tutor Support: Tutor support is included</li> <li>Customer Support: 24/7 customer support is available</li> <li>Quality Training: The course is designed by an industry expert</li> <li>Recognised Credential: Recognised and Valuable Certification</li> <li>Completion Certificate: Free Course Completion Certificate Included</li> <li>Instalment: 3 Installment Plan on checkout</li> </ul> </div> </div> <div> <div> <hr /> <h3>What you will learn from this course?</h3> <ul> <li>Gain comprehensive knowledge about Microsoft Office Excel</li> <li>Understand the core competencies and principles of Microsoft Office Excel</li> <li>Explore the various areas of Microsoft Office Excel</li> <li>Know how to apply the skills you acquired from this course in a real-life context</li> <li>Become a confident and expert office admin</li> </ul> </div> </div> <div> <div> <div> <hr /> <div> <div> <div> <h3>Microsoft Excel 2016: Data Analysis with PivotTables Course</h3> Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive excel data analysis course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel data analysis course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this excel data analysis course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. </div> <div> <h3>Who is this Course for?</h3> This comprehensive excel data analysis course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. </div> <div> <h3>Entry Requirements</h3> This excel data analysis course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. </div> <div> <h3>Assessment</h3> This excel data analysis course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. </div> <div> <h3>Advance Your Career</h3> This excel data analysis course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. </div> </div> </div> </div> </div> </div> </div> </div><h3>Recognised Accreditation</h3> This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement.<div> <h3> Course Curriculum </h3> <div> <table> <tbody><tr> <td colspan="4">Introduction</td> </tr> <tr> <td></td> <td> Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td colspan="4">Preparing Data and Creating Pivot Tables</td> </tr> <tr> <td></td> <td> Prepare Data - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Prepare Data </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Create a PivotTable - Introduction </td> <td> </td> <td> 00:07:00</td> </tr> <tr> <td></td> <td> Create a PivotTable from a Local Data Source </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td></td> <td> Create a PivotTable from Multiple Local Data Sources </td> <td> </td> <td> 00:07:00</td> </tr> <tr> <td></td> <td> Create a PivotTable from an External Data Sources </td> <td> </td> <td> 00:07:00</td> </tr> <tr> <td colspan="4">Analyzing Data by Using PivotTables</td> </tr> <tr> <td></td> <td> Summarize PivotTable Data - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Summarize Pivottable Data </td> <td> </td> <td> 00:07:00</td> </tr> <tr> <td></td> <td> Organize PivotTable Data - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Organize PivotTable Data </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td></td> <td> Filter Pivottable Data </td> <td> </td> <td> 00:07:00</td> </tr> <tr> <td></td> <td> Format a PivotTable - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Format a PivotTable </td> <td> </td> <td> 00:03:00</td> </tr> <tr> <td></td> <td> Refresh and Change PivotTable Data - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Refresh and Change PivotTable Data </td> <td> </td> <td> 00:06:00</td> </tr> <tr> <td colspan="4">Working with PivotCharts</td> </tr> <tr> <td></td> <td> Create a PivotChart - Introduction </td> <td> </td> <td> 00:01:00</td> </tr> <tr> <td></td> <td> Create a PivotChart </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td></td> <td> Manipulate PivotChart Data </td> <td> </td> <td> 00:04:00</td> </tr> <tr> <td></td> <td> Format a PivotChart </td> <td> </td> <td> 00:05:00</td> </tr> <tr> <td colspan="4">Obtain Your Certificate</td> </tr> <tr> <td></td> <td> Order Your Certificate of Achievement </td> <td> </td> <td> 00:00:00</td> </tr> <tr> <td colspan="4">Get Your Insurance Now</td> </tr> <tr> <td></td> <td> Get Your Insurance Now </td> <td> </td> <td> 00:00:00</td> </tr> <tr> <td colspan="4">Feedback</td> </tr> <tr> <td></td> <td> Feedback </td> <td> </td> <td> 00:00:00</td> </tr> </tbody></table></div> </div>

Microsoft Excel 2016: Data Analysis with PivotTables Course

Microsoft Excel Diploma

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

Microsoft Excel 2016: Part 3 (Expert Level) Course

Microsoft Excel Online Training

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

 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

			</div>

Microsoft Excel For Beginners

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

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





Property SQ2

Wealth Management

Property Investment

Real Estate Investing

Passive Income

Investment

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

Discover Property to Pounds

Webinar Seat



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


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


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


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


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


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


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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Microsoft Excel

Professional Development

Continuous Professional Development (CPD)

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

Southend-On-Sea

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

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



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

Let’s Do Business Group

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

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

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

Financial Analysis

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

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

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



On this course, you will…

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


Who will benefit from this course:

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


Course Outline

Module 1: What is and why buy Real Estate?

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


Module 2: The Real Estate Market System

The Space Market
The Asset Market
The Development Market


Module 3: How to value Real Estate

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


Module 4: How to read a Real Estate Market Report

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


Module 5: Who works in Real Estate?

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


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

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

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

DG Legal

Anti-Money Laundering (AML)

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

General Delegate

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

Retainer Delegate

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

Nexus Human

Office Skills & Productivity

Office Skills

Excel Analytics

Microsoft Office

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

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



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

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

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

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


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


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

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

Real Estate Finance (Debt Financing)

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

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

6404 Courses

Microsoft Excel For Business

By Study Plex

Retail Analytics In Microsoft Excel Diploma

By Study Plex

Dynamic Arrays in Excel Program

By Study Plex

Microsoft Office Excel 2016: Part 1 Beginner Level Course

By Study Plex

Microsoft Excel For Data Visualization

By Study Plex

Microsoft Excel 2016: Data Analysis with PivotTables Course

By Study Plex

Microsoft Excel Diploma

By Study Plex

Microsoft Excel 2016: Part 3 (Expert Level) Course

By Study Plex

Microsoft Excel Online Training

By Study Plex

Microsoft Excel For Beginners

By Study Plex

Search By Location