Name: Inside an Artists mind Vibrant Labrador in Acrylics 1 hour
Price: 8.99 GBP
Availability: InStock

<p><strong>Get inside my mind as I work out how to paint this magnificent&nbsp; pig in colourful Vibrant acrylics.</strong></p>
<p><strong>Step by step instruction 48mins</strong></p>
<p>All materials are listed at the begining of the tuition plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.</p>
<p><strong>UNLIMITED LINK </strong>&nbsp;Tuitions for a UNLIMITED time. (Won&rsquo;t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,</p>

Get inside my mind as I work out how to paint this magnificent pig in colourful Vibrant acrylics.
Step by step instruction 48mins
All materials are listed at the begining of the tuition plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.
UNLIMITED LINK  Tuitions for a UNLIMITED time. (Won’t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,

Marilyn Allis

Acrylic Painting

Get inside my mind as I work out how to paint this magnificent  lion in colourful Vibrant acrylics.

Inside an Artists mind Vibrant pig in Acrylics 48 mins

General admission

<p><strong>Get inside my mind as I work out how to paint this magnificent&nbsp; lion in colourful Vibrant acrylics.</strong></p>
<p><strong>Step by step instruction 45mins</strong></p>
<p>All materials are listed at the begining of the tuition plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.</p>
<p><strong>UNLIMITED LINK </strong>&nbsp;Tuitions for a UNLIMITED time. (Won&rsquo;t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,</p>

Get inside my mind as I work out how to paint this magnificent lion in colourful Vibrant acrylics.
Step by step instruction 45mins
All materials are listed at the begining of the tuition plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.
UNLIMITED LINK  Tuitions for a UNLIMITED time. (Won’t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,

Inside an Artists mind Vibrant Lion in Acrylics 45 mins

<p><strong>Get inside my mind as I work out how to paint this magnificent&nbsp; Tiger in colourful Vibrant acrylics.</strong></p>
<p><strong>Step by step instruction 54mins</strong></p>
<p>All materials are listed at the begining of the tuition plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.</p>
<p><strong>UNLIMITED LINK </strong>&nbsp;Tuitions for a UNLIMITED time. (Won&rsquo;t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,</p>

Get inside my mind as I work out how to paint this magnificent Tiger in colourful Vibrant acrylics.
Step by step instruction 54mins
All materials are listed at the begining of the tuition plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.
UNLIMITED LINK  Tuitions for a UNLIMITED time. (Won’t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,

Get inside my mind as I work out how to paint this magnificent  tiger in colourful Vibrant acrylics.

Inside an Artists mind Vibrant Tiger in Acrylics 49mins

<p><strong>The light is awsome in Morocco, Using the lights and the darks to really make your painting come alive.</strong></p>
<p><strong>Step by step instruction 20mins</strong></p>
<p>All materials are listed at the begining of the tution plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.</p>
<p><strong>UNLIMITED LINK </strong>&nbsp;Tuitions for a UNLIMITED time. (Won&rsquo;t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,</p>

The light is awsome in Morocco, Using the lights and the darks to really make your painting come alive.
Step by step instruction 20mins
All materials are listed at the begining of the tution plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.
UNLIMITED LINK  Tuitions for a UNLIMITED time. (Won’t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,

Watercolour Painting

The light is awsome in Morocco, Using the lights and the darks to really make your painting come alive.

Marrakech Medina in watercolour 58mins

<p><strong>Light and dark shapes bring the Venetian waters alive. That sparkle of light hitting the canal.</strong></p>
<p><strong>Step by step instruction 47mins</strong></p>
<p>All materials are listed at the begining of the tution plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.</p>
<p><strong>UNLIMITED LINK </strong>&nbsp;Tuitions for a UNLIMITED time. (Won&rsquo;t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,</p>

Light and dark shapes bring the Venetian waters alive. That sparkle of light hitting the canal.
Step by step instruction 47mins
All materials are listed at the begining of the tution plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.
UNLIMITED LINK  Tuitions for a UNLIMITED time. (Won’t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,

Light and dark shapes bring the Venetian waters alive. That sparkle of light hitting the canal.

Vibrancy in Venice in watercolour 47mins

<p><strong>Capture the iconic cobb in watercolour using just a few colours, with some really usefull tips for texture.</strong></p>
<p><strong>Step by step instruction 42mins</strong></p>
<p>All materials are listed at the begining of the tution plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.</p>
<p><strong>UNLIMITED LINK </strong>&nbsp;Tuitions for a UNLIMITED time. (Won&rsquo;t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,</p>

Capture the iconic cobb in watercolour using just a few colours, with some really usefull tips for texture.
Step by step instruction 42mins
All materials are listed at the begining of the tution plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.
UNLIMITED LINK  Tuitions for a UNLIMITED time. (Won’t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,

Capture the cobb Lyme Regis in watercolour easily, using minimal colours and learning unusual techniques in a fun way.

A winters day on the Cobb, Lyme Regis in watercolour 

Surbiton

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-key="2" fr-original-style="" style="box-sizing: border-box;">Spiritual Awakening Level 1 Online is the beginning of a journey of self-discovery, vitality, and a happier and harmonic way of being. It allows your TRUE soul essence to light the way as blockages are reduced and cleared.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(105, 105, 105); font-family: roboto, helvetica neue, helvetica, arial, sans-serif; box-sizing: border-box;" fr-original-style="color: #696969; font-family: roboto, helvetica neue, helvetica, arial, sans-serif;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who Is This Course For?</strong></em><br fr-original-style="" style="box-sizing: border-box;">It is a beautiful fit if...&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(105, 105, 105); font-family: roboto, helvetica neue, helvetica, arial, sans-serif; box-sizing: border-box;" fr-original-style="color: #696969; font-family: roboto, helvetica neue, helvetica, arial, sans-serif;">✅ You are feeling, maybe even seeing things that you are not sure about.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(105, 105, 105); font-family: roboto, helvetica neue, helvetica, arial, sans-serif; box-sizing: border-box;" fr-original-style="color: #696969; font-family: roboto, helvetica neue, helvetica, arial, sans-serif;">✅ &nbsp;You feel highly sensitive or have become more sensitive than before and do not know how to manage it or do with it.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(105, 105, 105); font-family: roboto, helvetica neue, helvetica, arial, sans-serif; box-sizing: border-box;" fr-original-style="color: #696969; font-family: roboto, helvetica neue, helvetica, arial, sans-serif;">✅ &nbsp;Your intuition is working overtime and you just feel different from how you did a week, a month or a year ago?</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(105, 105, 105); font-family: roboto, helvetica neue, helvetica, arial, sans-serif; box-sizing: border-box;" fr-original-style="color: #696969; font-family: roboto, helvetica neue, helvetica, arial, sans-serif;">If yes to all or any of these then Now Is Your Chance...to know, understand and embrace what is happening.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(105, 105, 105); font-family: roboto, helvetica neue, helvetica, arial, sans-serif; box-sizing: border-box;" fr-original-style="color: #696969; font-family: roboto, helvetica neue, helvetica, arial, sans-serif;">After the course...&nbsp;</span></strong></em></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(105, 105, 105); font-family: roboto, helvetica neue, helvetica, arial, sans-serif; box-sizing: border-box;" fr-original-style="color: #696969; font-family: roboto, helvetica neue, helvetica, arial, sans-serif;">Walk away knowing:-<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">✨&nbsp;</strong>Step by Step guidelines for implementing Reiki <br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">✨&nbsp;</strong>Ways to<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong>Intuitively Connect with the Higher Universal energy for healing<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">✨&nbsp;</strong>How and Why to protect your energy from other<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">✨&nbsp;</strong>Mastery of the Sacred Reiki Symbols for strength and enhancement<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">✨</strong>Ways to enhance your life, career and goals</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-key="32" fr-original-style="" style="box-sizing: border-box;">Receive a comprehensive manual, Accredited Reiki level 1 certificate, 3 zoom check in&#39;s, Traditional Reiki lineage, and unlimited lifetime support.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-key="36" fr-original-style="" style="box-sizing: border-box;">What are you waiting for&nbsp;</span><a href="https://www.steph-edwards.com/events-reiki-1?tag=Reiki%20Level%201&category=Reiki%20Course" 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;"></a><span data-key="36" fr-original-style="" style="box-sizing: border-box;"><a href="https://www.steph-edwards.com/events-reiki-1?tag=Reiki%20Level%201&category=Reiki%20Course" rel="noopener noreferrer" target="_blank" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">REGISTER NOW</a></span><span data-key="36" fr-original-style="" style="box-sizing: border-box;">&nbsp;for a fuller happier and more magical life?</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-key="36" fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Zoom Link will be emailed a few days before the course date</strong></em><br fr-original-style="" style="box-sizing: border-box;"></span></p>

Spiritual Awakening Level 1 Online is the beginning of a journey of self-discovery, vitality, and a happier and harmonic way of being. It allows your TRUE soul essence to light the way as blockages are reduced and cleared. 
Who Is This Course For?
It is a beautiful fit if... 
✅ You are feeling, maybe even seeing things that you are not sure about.
✅ You feel highly sensitive or have become more sensitive than before and do not know how to manage it or do with it.
✅ Your intuition is working overtime and you just feel different from how you did a week, a month or a year ago?
If yes to all or any of these then Now Is Your Chance...to know, understand and embrace what is happening.
After the course... 
Walk away knowing:-
✨ Step by Step guidelines for implementing Reiki 
✨ Ways to Intuitively Connect with the Higher Universal energy for healing
✨ How and Why to protect your energy from other
✨ Mastery of the Sacred Reiki Symbols for strength and enhancement
✨Ways to enhance your life, career and goals
Receive a comprehensive manual, Accredited Reiki level 1 certificate, 3 zoom check in's, Traditional Reiki lineage, and unlimited lifetime support.
What are you waiting for REGISTER NOW for a fuller happier and more magical life?
Zoom Link will be emailed a few days before the course date


Stephanie Edwards

Spiritual Healing

Energy Healing

Reiki Healer

This course enables you to use Reiki for self-healing and on friends and family. The fee for Reiki Level 1 is £129. Reiki Level 1 is a one half day course with bonus knowledge of the first Reiki Symbol. Theory is online, practical and attunement done in person

Spiritual Awakening Usui Reiki Lv1 Online

General Admission

<p><strong>Get inside my mind as I work out how to paint this awesome memory in colourful Vibrant acrylics.</strong></p>
<p><strong>Step by step instruction 1 hour 32mins</strong></p>
<p>All materials are listed at the begining of the tuition plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.</p>
<p><strong>UNLIMITED LINK </strong>&nbsp;Tuitions for a UNLIMITED time. (Won&rsquo;t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,</p>

Get inside my mind as I work out how to paint this awesome memory in colourful Vibrant acrylics.
Step by step instruction 1 hour 32mins
All materials are listed at the begining of the tuition plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.
UNLIMITED LINK  Tuitions for a UNLIMITED time. (Won’t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,

Get inside my mind as I work out how to paint this awesome memory in colourful Vibrant acrylics.

Inside an Artists mind Vibrant Acrylics Red, Red wine 1 hour 32 mins

<p><strong>Get inside my mind as I work out how to paint this awesome memory in colourful Vibrant acrylics.</strong></p>
<p><strong>Step by step instruction 1 hour 49mins</strong></p>
<p>All materials are listed at the begining of the tuition plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.</p>
<p><strong>UNLIMITED LINK </strong>&nbsp;Tuitions for a UNLIMITED time. (Won&rsquo;t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,</p>

Get inside my mind as I work out how to paint this awesome memory in colourful Vibrant acrylics.
Step by step instruction 1 hour 49mins
All materials are listed at the begining of the tuition plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.
UNLIMITED LINK  Tuitions for a UNLIMITED time. (Won’t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,

Inside an Artists mind Vibrant Bouzios Brazil Acrylics 1 hour 13 mins

<p><strong>Get inside my mind as I work out how to paint this magnificent&nbsp; labrador in colourful Vibrant acrylics.</strong></p>
<p><strong>Step by step instruction 1 hour</strong></p>
<p>All materials are listed at the begining of the tuition plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.</p>
<p><strong>UNLIMITED LINK </strong>&nbsp;Tuitions for a UNLIMITED time. (Won&rsquo;t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,</p>

Get inside my mind as I work out how to paint this magnificent labrador in colourful Vibrant acrylics.
Step by step instruction 1 hour
All materials are listed at the begining of the tuition plus the reference photographs and drawing will be sent to you at the time of purchase. Captions are reminding you of the size of brushes colours etc. You can stop at any point to catch up.
UNLIMITED LINK  Tuitions for a UNLIMITED time. (Won’t time out) You can watch them on your smart TV, PC, tablet or phone., which you can watch as many times as you wish,

Get inside my mind as I work out how to paint this magnificent  Labrador in colourful Vibrant acrylics.

Inside an Artists mind Vibrant Labrador in Acrylics 1 hour

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><img src="https://images.cademy.co.uk/art-by-purnima/1f946b6c-ddfc-4430-8148-ab1d607d7f51/original.jpeg" style="width: 167px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 167px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable">For all my amazing reviews please click the link below:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a data-fr-linked="true" href="https://www.craftcourses.com/providers/art-by-purnima/reviews" id="isPasted" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://www.craftcourses.com/providers/art-by-purnima/reviews</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 4-week Online Course is suitable for complete beginners and improvers who would like to learn to paint in Watercolour.<br fr-original-style="" style="box-sizing: border-box;">Each session is 40 minutes and starts at 10.00-10.40 am<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* You will learn to prepare your watercolour paints and mix colours.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* You will learn a variety of watercolour techniques including, washes, wet in wet, graded, dry brush Flat Wash, and Loose watercolours see photos.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">*You will be taught live by your tutor online with step-by-step demonstrations and clear explanations of the various stages.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* Learners will then carry the various tasks alongside the tutor who will be at hand for any questions that you may have.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">This is a 4 week course offered live online via zoom and the course is ongoing so you can join at any time.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-class="cancellation-policy">Cancellation and a full refund can be obtained up to 2 weeks before the course starts. Start dates may be amended on request.</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What&#39;s included in the price?</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Online Tuition<br fr-original-style="" style="box-sizing: border-box;">Step by step Demonstrations via Zoom in the live class<br fr-original-style="" style="box-sizing: border-box;">Clear explanation from your Tutor<br fr-original-style="" style="box-sizing: border-box;">Reference handouts sent via email</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What you will need</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Start Kit Available from Tutor please email for details<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Watercolour paints - tubes or pans<br fr-original-style="" style="box-sizing: border-box;">Watercolour paper ( Cold Pressed 300 gsm 140lb)<br fr-original-style="" style="box-sizing: border-box;">Round watercolour brushes- size 4 and 6 ( or similar)<br fr-original-style="" style="box-sizing: border-box;">HB graphite pencil to draw image<br fr-original-style="" style="box-sizing: border-box;">Eraser<br fr-original-style="" style="box-sizing: border-box;">Mixing Palette<br fr-original-style="" style="box-sizing: border-box;">2 x jars of clean water<br fr-original-style="" style="box-sizing: border-box;">Kitchen paper<br fr-original-style="" style="box-sizing: border-box;">Hairdryer<br fr-original-style="" style="box-sizing: border-box;">Sketchbook<br fr-original-style="" style="box-sizing: border-box;">Tracing paper</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>


For all my amazing reviews please click the link below:
https://www.craftcourses.com/providers/art-by-purnima/reviews


This 4-week Online Course is suitable for complete beginners and improvers who would like to learn to paint in Watercolour.
Each session is 40 minutes and starts at 10.00-10.40 am

* You will learn to prepare your watercolour paints and mix colours.

* You will learn a variety of watercolour techniques including, washes, wet in wet, graded, dry brush Flat Wash, and Loose watercolours see photos.

*You will be taught live by your tutor online with step-by-step demonstrations and clear explanations of the various stages.

* Learners will then carry the various tasks alongside the tutor who will be at hand for any questions that you may have.

This is a 4 week course offered live online via zoom and the course is ongoing so you can join at any time.
Cancellation and a full refund can be obtained up to 2 weeks before the course starts. Start dates may be amended on request.
What's included in the price?
Online Tuition
Step by step Demonstrations via Zoom in the live class
Clear explanation from your Tutor
Reference handouts sent via email
What you will need
Start Kit Available from Tutor please email for details

Watercolour paints - tubes or pans
Watercolour paper ( Cold Pressed 300 gsm 140lb)
Round watercolour brushes- size 4 and 6 ( or similar)
HB graphite pencil to draw image
Eraser
Mixing Palette
2 x jars of clean water
Kitchen paper
Hairdryer
Sketchbook
Tracing paper







Art By Purnima

Watercolour for All 4 week Online Course Monday Morning Via Zoom

London

<article id="cincluded">
					<div>
						<h5>SQL Course Summary.</h5>
					</div>
					<div></div>
					<p>
						
						<br />Practical SQL course, to leavy you full conversant with queries, DML and DDL statements.
						<br />Hands-on, Practical SQL course. 
						<br />PCWorkshops SQL Course Certificate.
						<br />Max 4 people per course, we keep it personalised. 
						
				  	</p>
	    		</article>

<div id="#">
							<div>
								<h5>Where is the SQL Course?</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>Online: </b>Instructor-led.</li>
									 <li><b>Classroom: </b>Request per email.</li> 
								</ul>
								</div>
							</article>
						</div>
						
					   	<div id="#">
							<div>
								<h5>SQL Course Materials</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>SQL Coding Examples </b>   </li>
									 <li><b>SQL Course Manuals and Notes: </b>In-depth reference materials </li>
									 <li><b>Exercises:</b> Practical exercises  </li> 
								</ul>
								</div>
							</article>
						</div>
						 
						
						<div id="#">
							<div>
								<h5>Payment Options</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>→  £750, Follow the booking link </li>	 
									<li>Arrange for installments</li>
								</ul>
								</div>
							</article>
						</div>
						
						<div id="#">
							<div>
								<h5>Included with SQL Course:</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>SQL Course Certificate on completion.
									</li><li>SQL Course Manual.
									</li><li>Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.
									</li><li>After the course, 1 free session for questions.
									</li><li>Max group size, online and in classroom, on this SQL Course is 4.</li>
								</ul>
								</div>
							</article>
						</div>
						

			   	<div id="cdetails">
					<div>
						<h5>Course Details</h5>
					</div>
					<article>
						<div>
							<h5>SQL Intermediate Course summary</h5>
						</div>
						<div></div>
						<div>
					 	<ul>
					    	 <br /><br /><b><li>DAY 1:</li></b>
						    <li><b>Session 1: </b>Database Concepts
							 
							<br />What is a database? 
							<br />Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema

							</li>	<li><b>Session 2: </b>Using the SQL client
							SQL Getting started and Logging in, Selecting a database, 
							Client commands, Entering and executing SQL statements, 
							Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, 
							Command line execution of SQL Scripts

							</li><li><b>Session 3: </b>Basic SQL SELECT statement
							<br />The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions.  
							<br />Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators.
							<br />Column aliases.
							<br />Arithmetic expressions.
							<br />Null functions ('IS NULL,' 'IS NOT NULL,' , "Isnull",'Coalesce').
							<br />The ORDER BY clause.
							
							
							</li><li><b>Session 4:</b> 
							<br />LIMIT / TOP  and Distinct Queries 
							<br />SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count),
							<br />Group By, 
							<br />Rollup with Group By, 
							<br />Having.
							</li>
							<li><b>Session 5:</b> Joins
							<br />SQL Cartesian products.
							<br />SQL Joins (Inner join, Left join, Right join, Full join).
							<br />Table aliases.
							<br />Natural joins, Multi-table joins.
							<br />Union, Union All queries.
							<br />Except/Minus, Simulating join with Intersect.
							</li>
							<br /><br /><b><li>DAY 2:</li></b>
							<li><b>Session 6:</b>
							<br />SQL Subqueries, Nested Subqueries, 
							<br />Correlated and uncorrelated subqueries. 
							<br />Global and Local Temp Tables.
							</li>
							<li><b>Session 7:</b>
							SQL Built-in Functions: <br />Numeric Functions (ABS, SIGN, MOD, etc.)
							<br />and String Functions (Locate, Left, Right, Concat, etc),
							<br />DATE and TIME functions.
							</li>
							<li><b>Session 8:</b>
							SQL Views (Create, alter and drop), 
							<br />Stored Procedures (Create, alter and drop, Input and Output parameters);
							<br /> Custom Functions (Create, alter and drop).
							</li>
							<br /><br /><b><li>DAY 3:</li></b>
							<li><b>
							Session 9: </b>Managing Data
							<br />Inserting rows, Replacing rows, Updating rows, Deleting rows,
<br />							The truncate statement, 
<br />The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
							</li>
							<li><b>
							Session 10:</b>
							SQL Indexes (Create, alter and drop).
							</li>
							<li><b>
							Session 11:</b>
							<br />Creating Databases and Tables (Create, alter and drop); <br />Constraints (Add, alter and drop).
							</li>
							<li><b>
							Session 12:</b>
							<br />Import data into SQL and Export from SQL.
							<br />Exporting using SQL, Importing using SQL.
														</li> 
							
							
						</ul>
						</div>
					</article>
				</div>

		<div> 
						 

						
				     
	                  <div></div>
 		</div>
	                
				     
				   <div id="booking">
	                  <div>
	                     <h5>Book the SQL Course</h5>
	                  </div>
							 
							 
<div id="eventbrite-widget-container-12009778571"></div>




					 
							 
							 
	               </div>
				   <div id="#">
	                  <div>
	                     <h5>About us</h5>
	                  </div>



	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_7KBtchhl8SMxqQ8TquAE3BxAGh2waJl4jxQdXEubLKJcmvn6ak"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>

SQL Course Intermediate 
 
This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements.  Hands-on, Practical SQL course.  
You will get the PCWorkshops SQL Course Certificate. 
Max 4 people per course, to keep it personalised. 
Where is the SQL Course?
Online: Instructor-led.
Classroom: Request per email.
SQL Course Materials
SQL Coding Examples
SQL Course Manuals and Notes: In-depth reference materials
Exercises: Practical exercises
Included with SQL Intermediate Course:
SQL Course Certificate on completion.
SQL Course Manual.
Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.
After the course, 1 free session for questions.
Max group size, online and in classroom, on this SQL Course is 4.
SQL Intermediate Course summary
DAY 1:
Session 1: Database Concepts 
What is a database? 
Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema
Session 2: Using the SQL client SQL Getting started and Logging in, Selecting a database, Client commands, Entering and executing SQL statements, Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, Command line execution of SQL Scripts
Session 3: Basic SQL SELECT statement 
The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions. 
Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators. 
Column aliases. 
Arithmetic expressions. 
Null functions ('IS NULL,' 'IS NOT NULL,' , "Isnull",'Coalesce'). 
The ORDER BY clause.
Session 4: 
LIMIT / TOP and Distinct Queries 
SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count), 
Group By, 
Rollup with Group By, 
Having.
Session 5: Joins 
SQL Cartesian products. 
SQL Joins (Inner join, Left join, Right join, Full join). 
Table aliases. 
Natural joins, Multi-table joins. 
Union, Union All queries. 
Except/Minus, Simulating join with Intersect.
DAY 2:
Session 6: 
SQL Subqueries, Nested Subqueries, 
Correlated and uncorrelated subqueries. 
Global and Local Temp Tables.
Session 7: SQL Built-in Functions: 
Numeric Functions (ABS, SIGN, MOD, etc.) 
and String Functions (Locate, Left, Right, Concat, etc), 
DATE and TIME functions.
Session 8: SQL Views (Create, alter and drop), 
Stored Procedures (Create, alter and drop, Input and Output parameters); 
 Custom Functions (Create, alter and drop).
DAY 3:
Session 9: Managing Data 
Inserting rows, Replacing rows, Updating rows, Deleting rows,

 The truncate statement, 
The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
Session 10: SQL Indexes (Create, alter and drop).
Session 11: 
Creating Databases and Tables (Create, alter and drop); 
Constraints (Add, alter and drop).
Session 12: 
Import data into SQL and Export from SQL. 
Exporting using SQL, Importing using SQL.
 
About us

Our SQL Intermediate trainers are experienced award winners.
13 years in business
We keep it practical and customised

PCWorkshops

Oracle SQL

Azure SQL Database

Microsoft SQL Server

Microsoft SQL

Database Programming

Computer Skills

SQL Server

MySQL

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements.  Hands-on, Practical SQL course.  
You will get the PCWorkshops SQL Course Certificate. 
Max 4 people per course, to keep it personalised. 

SQL Intermediate Course, 3 Days

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Financial Modelling School (5 days)</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance &amp; Risk.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The school combines three of our courses:</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Analyst</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investor</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Modelling Masterclass</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">All of the courses are interlinked to give you a full understanding of the subject using Excel.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will&hellip;</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Implement cash flows in excel throughout the whole week.</li><li value="2" fr-original-style="" style="box-sizing: border-box;">In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.</li><li value="3" fr-original-style="" style="box-sizing: border-box;">On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this school?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Property industry modellers who would like to be fully proficient in building complex financial models</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Analyst I</em></em></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.</em></em></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Analyst II</em></em></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.</em></em></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Three</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Investor I</em></em></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Modelling sector variations in real estate income streams i.e. Office versus industrial, retail &amp; leisure</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Further senior debt covenants</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance Rent Function techniques to manage feature rich lease structures</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Four</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Investor II</em></em></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Introduction to development appraisals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Residual models, site and profit calculations</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Development cash flows versus Investment cash flows</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introduction to straight line versus S-curve costing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Phased asset sales in development appraisals</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Discounting development cash flows</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Complimentary return metrics for development appraisals</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Introduction to development finance</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Five</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Modelling Masterclass</em></em></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Financial Modelling School such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



Real Estate Financial Modelling School (5 days)
The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.
This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.
The school combines three of our courses:
Real Estate Analyst
Real Estate Investor
Real Estate Modelling Masterclass


All of the courses are interlinked to give you a full understanding of the subject using Excel.


On this course you will…
Implement cash flows in excel throughout the whole week.
In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.
On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.
Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.


Who will benefit from this school?
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Mid-level to senior Real Estate Analysts
Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail
Property industry modellers who would like to be fully proficient in building complex financial models


Course Outline
Day One
Real Estate Analyst I
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Real Estate Analyst II
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Day Three
Real Estate Investor I
Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy
Modelling sector variations in real estate income streams i.e. Office versus industrial, retail & leisure
Further senior debt covenants
Advance Rent Function techniques to manage feature rich lease structures


Day Four
Real Estate Investor II
Introduction to development appraisals
Residual models, site and profit calculations
Development cash flows versus Investment cash flows
Introduction to straight line versus S-curve costing
Phased asset sales in development appraisals
Discounting development cash flows
Complimentary return metrics for development appraisals
Introduction to development finance


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


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


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

Bayfield Training

Real Estate Finance

Microsoft Excel

Professional Development

Continuous Professional Development (CPD)

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

Real Estate Financial Modelling School

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Analyst</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to structure an investment cash flow from first principles and how to value and appraise property investments</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Build annual and quarterly discounted cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Build OPEX and CAPEX into your cash flow</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse risk using sensitivity tables and charts</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Portfolio Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Investment Managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset Managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="9" fr-original-style="" style="box-sizing: border-box;">APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



Real Estate Analyst
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.


On this course, you will…
Learn how to structure an investment cash flow from first principles and how to value and appraise property investments
Build annual and quarterly discounted cash flows
Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
Build OPEX and CAPEX into your cash flow
Analyse risk using sensitivity tables and charts
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Real Estate Investors
Surveyors
Portfolio Analysts
Investment Managers
Asset Managers
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.


Day One
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


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


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

Financial Modelling & Analysis

Financial Modelling

Property & Real Estate Photography

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

<article>
<div>
<h5>Java EVENINGS Course</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>Python EVENINGS Course. </b>Basic Python syntax and principles of Object Orientated Programming. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Python Basics EVENINGS Course </h5>
	  </div>
	  <div></div>
	  <p> 
 
				This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom.
				This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language.
				These concepts are daily used by programmers and is your first step to working as a programmer.
				By the end, you'll be comfortable in programming Python code.
				You will have done small projects.
				This will serve for you as examples and samples that you can use to build larger projects.
				You can publish your code online to keep as a portfolio.

<br />
This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered.

	  </p>
	<div>
	<h5>Week 1: Basics</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Python Data Types and Variables:</strong>  
					<br />  Primitive types; Characters &amp; Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.	 
					<br /> <strong>Operators and Expressions: </strong>   
					<br />  Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.
					</p> 
			 
				<p><strong> Decision Making:</strong>
				<br />If statement; If - else statement; If- elif - else statement; Nested if - else.
				</p><p><strong>Using Loops:</strong>
				<br />The while, while-else.
				<br />For loop;
				<br />Jump statements: break, continue;
				<br />Nesting loops.				
				</p>
			</div>
	<div>
	<h5>Week 2: Data Structures</h5>
	</div> <div></div>
	<div> 
				<p> Lists.
					<br />Tuples.
					<br />Sets.
					<br />Dictionary. Nested Dictionary.
					<br />Json Files.
				</p>
			</div>
	<div>
	<h5>Week 3: Python built-in functions</h5>
	</div> <div></div>
	<div> 
				<p>  
				<br />Using Built-in modules and functions:
				<br />Strings Functions.
				<br />Pattern matching with Regex.
				<br />Maths Functions.
				<br />Random Functions.
				<br />Python Date functions.
				</p>
			</div>
	<div>
	<h5>Week 4: OOP: Using Modules, functions, classes</h5>
	</div> <div></div>
	<div>
				<p>  Creating and using custom Functions.
					<br />Creating functions;
					<br />Using parameters and return values;
					<br />
					<br />Introduction to Classes and Objects:
					<br />Creating a Class; 
					<br />Creating an Object; Using an Object; 
					<br />Adding Instance variables; Controlling accessibility; Naming conventions for class members. 
					<br /> Class Constructors; Parameterized Constructors.
					<br />Inheritance. Overload.
				</p>
			</div>

	<div>
	<h5>Week 5: Pandas DataBase Basics</h5>
	</div> <div></div>
	<div>	 
		<p> <b>Connection details:</b>
				Connect to a database using access codes. 
				<br /><b>Select Queries:</b>
				Retrieving records and iterating results sets, using variables and parameters in queries. 
				<br />Working with DDL comands:
				Create a database, drop a database.
				Create a table, alter tables, drop a table. 
				<br />Working with DML Commands:
				Insert, delete, update records.
		</p>
	</div>
	
	 
	<div>
	<h5>Week 6: Pandas Dataframe Basics</h5>
	</div> <div></div>
	<div>	 
		<p> Getting data into a dataframe:
			<br />Dict to Dataframe, Dataframe to Dict.
			<br />Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.

			<br />Dataframe basics:
			<br />Slicing Dataframes,
			<br />Getting information about the dataframe,
			<br />Filter, sort and query a Dataframes,
			<br />Duplicate values,
			<br />Working with null-values,
			<br />Sampling,
			<br />Group by,
			<br />Join.

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>Python Course Notes</li>
				<li>Python Code Examples</li>
				<li>Practical Python Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the Python  Course</h5>
	                  </div>
 
<div id="eventbrite-widget-container-60636103217"></div>




							 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Python EVENINGS Course
Basic Python syntax and principles of object-oriented programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details:
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 4 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
How to attend:  
Connection Link For the course: https://meet.goto.com/910697125
Once you have made the payment, use the above link on the date booked, to connect with the trainer. 
Python Basics EVENINGS Course
 This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects. You can publish your code online to keep as a portfolio. 

This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered. 
Week 1: Basics
 Python Data Types and Variables: 
Primitive Data types; Working with variables and its scope; Conversion and casting types in Python. 
 Operators and Expressions:  
 Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators. 
 Decision Making: 
If statement; If - else statement; If- elif - else statement; Nested if - else. 
Using Loops: 
The while, while-else. 
For loop; 
Jump statements: break, continue; 
Nesting loops. 
Week 2: Data Structures & Database
Lists.  
Tuples. 
Sets. 
Dictionary. Nested Dictionary. 
Json Files. 
Reading csv and text files
Connecting with a database and run SQL Queries. 
Week 3: Python built-in functions &  Pandas Dataframe Basics
 
Using built-in modules and functions: 
Strings Functions. 
Maths Functions. 
Random Functions. 
Data Frames; 
Getting data into a dataframe: 
Dict to Dataframe, Dataframe to Dict.  
Dataframe basics: 
Slicing Dataframes, 
Getting information about the dataframe, 
Filter and query a Dataframes, 
Working with null-values.
Week 4: OOP: Using Modules, functions, classes
 Creating and using custom Functions. 
Creating functions; 
Using parameters and return values; 
 
Introduction to Classes and Objects: 
Creating a Class; 
Creating an Object; Using an Object; 
Adding instance variables; controlling accessibility; and naming conventions for class members. 
 Class Constructors; Parameterized Constructors. 
Inheritance. Overload. 

What is included
PCWorkshops Course Certificate on completion
Python Course Notes
Python Code Examples
Practical Python Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  

Online Course Creation

Programming Fundamentals

Computer Programming

Professional Skills Course (PSC)

Instructor

Python

Basic Python syntax and principles of Object Orientated Programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 

Python EVENINGS Course, Online Instructor-led

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is intended for people who use PowerPoint for their business communication needs.</p>Overview<p>To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders.</p><p>This course is intended for those who wish to take advantage of the application for high quality business presentations and reports.</p></div><div id="course-pills-2"><h4>Presentations</h4><ul><li>Create Attractive Presentations from Existing PowerPoint Templates</li><li>Creating Presentations Quickly using Outline to build a Structure</li><li>Incorporating and reusing slides from other presentations into your own</li></ul><h4>Templates and Customization</h4><ul><li>Using Slide Layouts</li><li>Using the Slide Master</li><li>Creating Custom Slide Layout</li></ul><h4>Working with Charts and Tables</h4><ul><li>Create and Modify Tables</li><li>Create Charts and Graphs</li><li>Copying Charts into PowerPoint</li><li>Link Vs Embed</li></ul><h4>Add Visual Elements to a Presentation</h4><ul><li>Create and Modify Shapes </li><li>Add Images </li><li>Create SmartArt to Make Easily Modifiable graphics </li><li>Use SmartArt to Give Dull Text a More Visual Appeal</li></ul><h4>Working with Media and Animation</h4><ul><li>Add Audio to A Presentation</li><li>Add Video to A Presentation</li><li>Add and Customize Animations</li><li>Add and Customize Transitions</li></ul><h4>Preparing to Present</h4><ul><li>Add Notes to A Presentation</li><li>Presenter View And Slide Show Controls</li><li>Create A Custom Slide Show </li><li>Saving and Sharing the Presentation </li><li>Printing Options and Handouts</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Microsoft PowerPoint for the Business User training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Microsoft PowerPoint for the Business User course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
1 Days
6 CPD hours
This course is intended for
This course is intended for people who use PowerPoint for their business communication needs.
Overview
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders.
This course is intended for those who wish to take advantage of the application for high quality business presentations and reports.
Presentations
Create Attractive Presentations from Existing PowerPoint Templates
Creating Presentations Quickly using Outline to build a Structure
Incorporating and reusing slides from other presentations into your own
Templates and Customization
Using Slide Layouts
Using the Slide Master
Creating Custom Slide Layout
Working with Charts and Tables
Create and Modify Tables
Create Charts and Graphs
Copying Charts into PowerPoint
Link Vs Embed
Add Visual Elements to a Presentation
Create and Modify Shapes
Add Images
Create SmartArt to Make Easily Modifiable graphics
Use SmartArt to Give Dull Text a More Visual Appeal
Working with Media and Animation
Add Audio to A Presentation
Add Video to A Presentation
Add and Customize Animations
Add and Customize Transitions
Preparing to Present
Add Notes to A Presentation
Presenter View And Slide Show Controls
Create A Custom Slide Show
Saving and Sharing the Presentation
Printing Options and Handouts
Additional course details:
Nexus Humans Microsoft PowerPoint for the Business User training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the Microsoft PowerPoint for the Business User course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


Nexus Human

Executive Presentation

Office Skills & Productivity

Microsoft Power Platform

Microsoft Powerpoint

Presentation Skills

Microsoft PowerPoint for the Business User

<article id="cincluded">
					<div>
						<h5>SQL Advanced Course Summary.</h5>
					</div>
					<div></div>
					<p>
						
						<br />Practical SQL Advanced Intensive Course
						, exploring the advanced and less commonly used SQL Statements and techniques.
						<br />We also learn Data Definition Language and Data Manipulation Language statements, 
						<br />as well as course automation of queries using T-SQL.
						<br />Hands-on, Practical SQL Advanced Course. 
						<br />PCWorkshops SQL Advanced Course Certificate.
						<br />Max 4 people per course, we keep it personalised. 
						
				  	</p>
	    		</article>

<div id="#">
							<div>
								<h5>Where is the SQL Advanced Course?</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>Online: </b>Instructor-led.</li>
									 <li><b>Classroom: </b>Request per email.</li> 
								</ul>
								</div>
							</article>
						</div>
						
					   	<div id="#">
							<div>
								<h5>SQL Advanced Course Materials</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>SQL Coding Examples </b>   </li>
									 <li><b>Manuals and Notes: </b>In-depth reference materials </li>
									 <li><b>Exercises:</b> Practical exercises  </li> 
								</ul>
								</div>
							</article>
						</div>
						 
						
						<div id="#">
							<div>
								<h5>Payment for SQL Course Advanced </h5>
							</div>
							<article>
								<div>
								<ul>
									<li>→  £600, Follow the booking link </li>	 
									<li>Arrange for installments</li>
								</ul>
								</div>
							</article>
						</div>
						
						<div id="#">
							<div>
								<h5>Included with SQL Advanced Course:</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>SQL Advanced Course Certificate on completion.
									</li><li>SQL Advanced Course Manual.
									</li><li>Practical SQL Advanced Course exercises
									</li><li>SQL Code Samples.
									</li><li>After the course, 1 free session for questions.
									</li><li>Max group size, online and in classroom, on this SQL Advanced Course is 4.</li>
								</ul>
								</div>
							</article>
						</div>
						

			   	<div id="cdetails">
					<div>
						<h5>SQL Course Advanced Topics</h5>
					</div>
					<article>
						<div>
							<h5>SQL ADVANCED COURSE TOPICS</h5>
						</div>
						<div></div>
						<div>
					 	<ul>
					    	<li>Database Concepts Revision:
								<br />What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,

								</li><li>SQL Sub-queries:

								<br />·Sub-queries in the WHERE, SELECT, From or Having clauses
								<br />·Using SOME, ALL, ANY and IN clauses in the Where Clause <br />·Self-contained sub-queries
								<br />·Correlated sub-queries
								<br />·Sub-queries with the EXISTS predicate

								</li><li>Derived Tables and CTEs:
								<br />·Using SQL derived tables
								<br />·SQL Common Table Expressions (CTEs)
								<br />·Recursive CTEs

								</li><li>Views:
								<br />Create, alter and drop Views, Indexes

								</li><li>SQL Stored Procedure Basics:
								<br />·Stored Procedure Principles
								<br />·Creating stored procedures
								<br />·Executing stored procedures
								<br />·System stored procedures

								</li><li>Variables:
								<br />·Declaring variables
								<br />·SET versus SELECT
								<br />Parameters and Return Values
								<br />·Passing parameters
								<br />·Default values and WHERE clauses
								<br />·Output parameters
								<br />·Using RETURN
								<br />·Testing Conditions
								<br />·The IF/ELSE statement
								<br />·CASE
								<br />·CHOOSE

								</li><li>Looping:
								<br />·Syntax of SQL WHILE
								<br />·Breaking out of a loop
								<br />·Basic transactions
								<br />·Beginning a transaction
								<br />·Committing/rolling back
								<br />·Deleting and updating
								<br />·Using DELETE and UPDATE
								<br />·Sys.Objects
								<br />·Dropping objects

								</li><li>User defined Functions:
								<br />Table Valued Functions
								<br />·In-line table-valued functions
								<br />·Multi- Statement table-valued functions
								<br />·Limitations of user-defined functions
								<br />Scalar Functions
								<br />·What are scalar functions?
								<br />·Some examples
								<br />·Disadvantages of scalar functions
								<br />·Three advantages

								</li><li>Cursors:
								<br />·Syntax of fetching rows
								<br />·When to use (and when not to)

								</li><li>Triggers:
								<br />·Create or replace triggers

								</li><li>Creating Tables in SQL:

								<br />·Create, alter and drop Tables
								<br />·Inserting values, single rows and multiple rows using queries
								</li><li>Constraints:
								<br />·Not Null, Unique,Default,Check,Primary Key,Foreign Key,Identity / Auto-increments

								</li><li>Sequencing
								</li><li>Indexes

								</li><li>SQL Temporary Tables and Table Variables:
								<br />·Create and use SQL temporary tables
								<br />·Create and use SQL table variables
								<br />·SQL Tables vs. Table Variables

								</li><li>Error-Handling:
								<br />·SQL TRY/CATCH
								<br />·SQL System error functions
								<br />·Customizing SQL error messages
								<br />·@@ error function

								</li><li>Debugging:
								<br />·The SQL Server debugger, Debugging (breakpoints, etc.)
							
							 
							
							</li>
						</ul>
						</div>
					</article>
				</div>

		<div> 
						 

						
				     
	                  <div></div>
 		</div>
	                
				     
				   <div id="booking">
	                  <div>
	                     <h5>BOOK THE SQL Course Advanced COURSE</h5> 
	                  </div>
							 
							 <div id="eventbrite-widget-container-48063008753"></div>




					 
	               </div>
				   <div id="#">
	                  <div>
	                     <h5>About SQL Course Advanced</h5>
	                  </div>



	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>

SQL Advanced Course 
 
Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. 
We also learn Data Definition Language and Data Manipulation Language statements, 
as well as course automation of queries using T-SQL. 
Hands-on, Practical SQL Advanced Course. 
PCWorkshops SQL Advanced Course Certificate. 
Max 4 people per course; we keep it personalised. 
Where is the SQL Advanced Course?
Online: Instructor-led.
Classroom: Request per email.
SQL Advanced Course Materials
SQL Coding Examples
Manuals and Notes: In-depth reference materials
Exercises: Practical exercises
 
Included with SQL Advanced Course:
SQL Advanced Course Certificate on completion.
SQL Advanced Course Manual.
Practical SQL Advanced Course exercises
SQL Code Samples.
After the course, 1 free session for questions.
Max group size, online and in classroom, on this SQL Advanced Course is 4.
SQL Course Advanced Topics
SQL ADVANCED COURSE TOPICS
Database Concepts Revision: 
What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,
SQL Sub-queries: 
·Sub-queries in the WHERE, SELECT, From or Having clauses 
·Using SOME, ALL, ANY and IN clauses in the Where Clause 
·Self-contained sub-queries 
·Correlated sub-queries 
·Sub-queries with the EXISTS predicate
Derived Tables and CTEs: 
·Using SQL derived tables 
·SQL Common Table Expressions (CTEs) 
·Recursive CTEs
Views: 
Create, alter and drop Views, Indexes
SQL Stored Procedure Basics: 
·Stored Procedure Principles 
·Creating stored procedures 
·Executing stored procedures 
·System stored procedures
Variables: 
·Declaring variables 
·SET versus SELECT 
Parameters and Return Values 
·Passing parameters 
·Default values and WHERE clauses 
·Output parameters 
·Using RETURN 
·Testing Conditions 
·The IF/ELSE statement 
·CASE 
·CHOOSE
Looping: 
·Syntax of SQL WHILE 
·Breaking out of a loop 
·Basic transactions 
·Beginning a transaction 
·Committing/rolling back 
·Deleting and updating 
·Using DELETE and UPDATE 
·Sys.Objects 
·Dropping objects
User defined Functions: 
Table Valued Functions 
·In-line table-valued functions 
·Multi- Statement table-valued functions 
·Limitations of user-defined functions 
Scalar Functions 
·What are scalar functions? 
·Some examples 
·Disadvantages of scalar functions 
·Three advantages
Cursors: 
·Syntax of fetching rows 
·When to use (and when not to)
Triggers: 
·Create or replace triggers
Creating tables in SQL: 
·Create, alter and drop Tables 
·Inserting values, single rows and multiple rows using queries
Constraints: 
·Not Null, Unique,Default, Check,Primary Key,Foreign Key,Identity / Auto-increments
Sequencing
Indexes
SQL Temporary Tables and Table Variables 
·Create and use SQL temporary tables 
·Create and use SQL table variables 
·SQL Tables vs. Table Variables
Error-Handling: 
·SQL TRY/CATCH 
·SQL System error functions 
·Customizing SQL error messages 
·@@ error function
Debugging: 
·The SQL Server debugger, Debugging (breakpoints, etc.)

About SQL Course Advanced
Our experienced trainers are award winners.
More about us
FAQ's
Client Comments

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. 
We also learn Data Definition Language and Data Manipulation Language statements. 
as well as course automation of queries using T-SQL. 
Hands-on, Practical SQL Advanced Course. 
PCWorkshops SQL Advanced Course Certificate. 
Max 4 people per course; we keep it personalised. 

SQL Course Advanced, 2 Days

<div style="color: rgb(88, 89, 91); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(88, 89, 91);"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Course Information</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This course offers foundational guidance and practical support tailored for individuals operating within Good Manufacturing Practice (GMP) frameworks.</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Explore the fundamental prerequisites of a pharmaceutical quality system (PQS) and delve into the application of quality risk management (QRM) principles, aligning with current regulations and guidance. Gain insights into pivotal aspects such as requirements, roles, and responsibilities, encompassing change control, document management, and key documentation essential for effective implementation of GMP with a focus on regulatory inspections and common findings.</p><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Is this course for you?</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Ideal for professionals engaged in GMP across various sectors, including:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Research and Development (R&amp;D)</li><li fr-original-style="" style="box-sizing: border-box;">Contract Manufacturing Organisations</li><li fr-original-style="" style="box-sizing: border-box;">Manufacturing Units</li><li fr-original-style="" style="box-sizing: border-box;">Quality Control (QC) Laboratories</li><li fr-original-style="" style="box-sizing: border-box;">Auditing Roles.</li></ul><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">What will you learn?</h2><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Event objectives - &nbsp;by the end of the course, delegates shall:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have an awareness of the basic requirements of GMP</li><li fr-original-style="" style="box-sizing: border-box;">Be aware of UK and EU GMP Rules and Guidance and relevant publications</li><li fr-original-style="" style="box-sizing: border-box;">Understand the roles and responsibilities associated with GMP</li><li fr-original-style="" style="box-sizing: border-box;">Be able to contribute to and maintain quality documentation</li><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of product lifecycle and manufacturing</li><li fr-original-style="" style="box-sizing: border-box;">Understand the requirements of GMP in the QC laboratory context</li><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of risk management and mitigation principles</li><li fr-original-style="" style="box-sizing: border-box;">Understand the need for quality systems and quality assurance activities</li><li fr-original-style="" style="box-sizing: border-box;">Be aware of common regulatory findings.</li></ul><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Learning outcomes: delegates will be able to:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Implement their role within GMP with confidence and knowledge of the principle requirements</li><li fr-original-style="" style="box-sizing: border-box;">Contribute effectively to the GMP quality system and their organisation&rsquo;s compliance</li><li fr-original-style="" style="box-sizing: border-box;">Comprehend where their organisation&rsquo;s activities sit within the larger GMP arena</li><li fr-original-style="" style="box-sizing: border-box;">Know where to seek further information within the published rules and guidance, UK Legislation, European Commission Directives, ICH Guidance and other relevant publications, as well as via the internet.</li></ul></div><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);"><br fr-original-style="" style="box-sizing: border-box;"></h2><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;"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Tutors</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tutors will be comprised of (click the photos for biographies):</p><img src="https://www.therqa.com/assets/tutors/17_eyd9QXJ.png" alt="Louise Handy" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Louise Handy</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Director, Handy Consulting Ltd</p><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><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;"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Programme</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please note timings may be subject to alteration.</p><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);"><br fr-original-style="" style="box-sizing: border-box;"></h3><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Day 1</h3><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">09:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Introductions and Scope of the Course</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Understand the group requirements and the tutor&#39;s background and experience.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">09:45</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Background and Regulatory Environment</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Setting the scene, understanding the context, key legislation.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">10:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Principles of GMP</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Key points and requirements.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">11:15</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Break</h4><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">11:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Personnel and Responsibilities</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Management and staff, duties and accountabilities.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">12:00</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Overview of GMP Manufacturing</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Basics of the product life cycle.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">12:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Lunch</h4><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">13:15</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Risk Management Workshop</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Practical exploration of risk and mitigation activities.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">14:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">QC Laboratories</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Activities and practicalities.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">15:15</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Break</h4><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">15:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Compliance</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quality Assurance and Self Inspection.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">16:15</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Question Time</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A chance for questions on the practicalities of GMP.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">16:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Close of Course</h4></div><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);"><br fr-original-style="" style="box-sizing: border-box;"></h2><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;"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Extra Information</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><ul data-tabs="op6z13-tabs" fr-original-style="" style="box-sizing: border-box;"></ul><div data-tabs-content="example-tabs" style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">Course Material</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please note this course will run in UK timezone.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">The advantages of this include:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Ability for delegates to keep material on a mobile device</li><li fr-original-style="" style="box-sizing: border-box;">Ability to review material at any time pre and post course</li><li fr-original-style="" style="box-sizing: border-box;">Environmental benefits &ndash; less paper being used per course Access to an online course group to enhance networking.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">You will need a stable internet connection, a microphone and a webcam.</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">CPD Points</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">7 Points</p></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(88, 89, 91);">&nbsp;</span></p><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">Development Level</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Learn</p></div>

Course Information
This course offers foundational guidance and practical support tailored for individuals operating within Good Manufacturing Practice (GMP) frameworks.
Explore the fundamental prerequisites of a pharmaceutical quality system (PQS) and delve into the application of quality risk management (QRM) principles, aligning with current regulations and guidance. Gain insights into pivotal aspects such as requirements, roles, and responsibilities, encompassing change control, document management, and key documentation essential for effective implementation of GMP with a focus on regulatory inspections and common findings.
Is this course for you?
Ideal for professionals engaged in GMP across various sectors, including:
Research and Development (R&D)
Contract Manufacturing Organisations
Manufacturing Units
Quality Control (QC) Laboratories
Auditing Roles.
What will you learn?
Event objectives - by the end of the course, delegates shall:
Have an awareness of the basic requirements of GMP
Be aware of UK and EU GMP Rules and Guidance and relevant publications
Understand the roles and responsibilities associated with GMP
Be able to contribute to and maintain quality documentation
Have a basic understanding of product lifecycle and manufacturing
Understand the requirements of GMP in the QC laboratory context
Have a basic understanding of risk management and mitigation principles
Understand the need for quality systems and quality assurance activities
Be aware of common regulatory findings.
Learning outcomes: delegates will be able to:
Implement their role within GMP with confidence and knowledge of the principle requirements
Contribute effectively to the GMP quality system and their organisation’s compliance
Comprehend where their organisation’s activities sit within the larger GMP arena
Know where to seek further information within the published rules and guidance, UK Legislation, European Commission Directives, ICH Guidance and other relevant publications, as well as via the internet.





Tutors
Tutors will be comprised of (click the photos for biographies):

Louise Handy
Director, Handy Consulting Ltd



Programme
Please note timings may be subject to alteration.


Day 1
09:30
Introductions and Scope of the Course
Understand the group requirements and the tutor's background and experience.
09:45
Background and Regulatory Environment
Setting the scene, understanding the context, key legislation.
10:30
Principles of GMP
Key points and requirements.
11:15
Break
11:30
Personnel and Responsibilities
Management and staff, duties and accountabilities.
12:00
Overview of GMP Manufacturing
Basics of the product life cycle.
12:30
Lunch
13:15
Risk Management Workshop
Practical exploration of risk and mitigation activities.
14:30
QC Laboratories
Activities and practicalities.
15:15
Break
15:30
Compliance
Quality Assurance and Self Inspection.
16:15
Question Time
A chance for questions on the practicalities of GMP.
16:30
Close of Course





Extra Information


Course Material


This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event.
Please note this course will run in UK timezone.
The advantages of this include:
Ability for delegates to keep material on a mobile device
Ability to review material at any time pre and post course
Environmental benefits – less paper being used per course Access to an online course group to enhance networking.

You will need a stable internet connection, a microphone and a webcam.


CPD Points
7 Points
 
Development Level
Learn

Research Quality Association

Introduction to Good Manufacturing Practice

RQA Member

Non Member

<h2 id="isPasted" style="color: rgb(45, 66, 76); box-sizing: border-box;" fr-original-style=" color: rgb(45, 66, 76);">What is the course about?</h2><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">You&#39;re a maker in your favoured medium - ceramics, wood, metal, glass or whatever - and you want to make electric lamps.</p><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">This course will tell you everything you need to know beyond using your existing skills in making the lamp base: design considerations; bulbs, bulb holders and lampshades; wiring; testing; and all the standards and regulations that you need to conform to (covering UK and EU requirements).</p><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">Note that although I am a potter, the course is not centered round the use of ceramics (or any other material) in making your lamp base.&nbsp;</p><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">The course is run over three weekly sessions, 19:00 &ndash; 20:30. These are recorded and put onto the course web page so you can view them at other times.</p><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">An additional discussion session will be set up at a time when most students can attend, even if not able to attend the live sessions - this will be scheduled at the start of the course.</p><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">In addition, a number of videos show the stages in wiring up and testing many types of lamp, and these can be watched from the course page.</p><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">The course page also has links to additional information that you may find useful.</p><h2 style="color: rgb(45, 66, 76); box-sizing: border-box;" fr-original-style=" color: rgb(45, 66, 76);">What will we cover?</h2><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">Lamp proportions and design considerations; basics of lighting; bulbs and bulb holders, switches and lampshades; electrical considerations and wiring up your lamp; testing your lamp; standards and regulations.</p><h2 style="color: rgb(45, 66, 76); box-sizing: border-box;" fr-original-style=" color: rgb(45, 66, 76);">What will I achieve?</h2><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">By the end of this course you should be able to&hellip;</p><ul style="color: rgb(91, 107, 114); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);"><li fr-original-style="" style="box-sizing: border-box;">Be familiar with the design proportions and considerations for different types of lamp, e.g. bedside, desktop, floor standing, wall or ceiling</li><li fr-original-style="" style="box-sizing: border-box;">Be familiar with the various options for light bulbs, bulb holders and switches</li><li fr-original-style="" style="box-sizing: border-box;">Understand the pros and cons of making a lamp that runs directly off the mains, or that uses a transformer</li><li fr-original-style="" style="box-sizing: border-box;">Be able to select the necessary components, and wire up, a lamp</li><li fr-original-style="" style="box-sizing: border-box;">Know how to test your lamps, what instrumentation is needed, and how manufacturing tests differ from PAT testing</li><li fr-original-style="" style="box-sizing: border-box;">Understand the standards and requirements and how they affect the design of your lamp</li><li fr-original-style="" style="box-sizing: border-box;">Be able to produce the necessary documentation to accompany your lamp, and know how to make it eligible to use the required CE / UKCA mark</li><li fr-original-style="" style="box-sizing: border-box;">Understand the principles behind WEEE, and the requirements this imposes on the maker and the retailer</li></ul><h2 style="color: rgb(45, 66, 76); box-sizing: border-box;" fr-original-style=" color: rgb(45, 66, 76);">What level is the course and do I need any particular skills?</h2><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">Intermediate. You should have the skills to make the lamp base in your preferred material, as that is not covered in the course though obviously necessary to make a lamp.&nbsp;</p><h2 style="color: rgb(45, 66, 76); box-sizing: border-box;" fr-original-style=" color: rgb(45, 66, 76);">What do I get?</h2><ul style="color: rgb(91, 107, 114); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);"><li fr-original-style="" style="box-sizing: border-box;">Three live sessions with questions and discussions, lasting about 90 minutes each week</li><li fr-original-style="" style="box-sizing: border-box;">Recordings of all sessions for later viewing on the course page</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Downloadable PDFs of all presentations</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">A set of videos on the course page taking you through assembling, wiring and testing of lamps</li><li fr-original-style="" style="box-sizing: border-box;">Additional optional online course material, giving background info and greater depth</li><li fr-original-style="" style="box-sizing: border-box;">A discussion session where you can ask anything related to the course or related matters - the date and time will be scheduled so most students can participate, including those unable to attend the live sessions</li><li fr-original-style="" style="box-sizing: border-box;">Premium level access to the Tech part of my web site, containing much more information, references etc.</li><li fr-original-style="" style="box-sizing: border-box;">Course completion certificate</li></ul>

What is the course about?
You're a maker in your favoured medium - ceramics, wood, metal, glass or whatever - and you want to make electric lamps.
This course will tell you everything you need to know beyond using your existing skills in making the lamp base: design considerations; bulbs, bulb holders and lampshades; wiring; testing; and all the standards and regulations that you need to conform to (covering UK and EU requirements).
Note that although I am a potter, the course is not centered round the use of ceramics (or any other material) in making your lamp base. 
The course is run over three weekly sessions, 19:00 – 20:30. These are recorded and put onto the course web page so you can view them at other times.
An additional discussion session will be set up at a time when most students can attend, even if not able to attend the live sessions - this will be scheduled at the start of the course.
In addition, a number of videos show the stages in wiring up and testing many types of lamp, and these can be watched from the course page.
The course page also has links to additional information that you may find useful.
What will we cover?
Lamp proportions and design considerations; basics of lighting; bulbs and bulb holders, switches and lampshades; electrical considerations and wiring up your lamp; testing your lamp; standards and regulations.
What will I achieve?
By the end of this course you should be able to…
Be familiar with the design proportions and considerations for different types of lamp, e.g. bedside, desktop, floor standing, wall or ceiling
Be familiar with the various options for light bulbs, bulb holders and switches
Understand the pros and cons of making a lamp that runs directly off the mains, or that uses a transformer
Be able to select the necessary components, and wire up, a lamp
Know how to test your lamps, what instrumentation is needed, and how manufacturing tests differ from PAT testing
Understand the standards and requirements and how they affect the design of your lamp
Be able to produce the necessary documentation to accompany your lamp, and know how to make it eligible to use the required CE / UKCA mark
Understand the principles behind WEEE, and the requirements this imposes on the maker and the retailer
What level is the course and do I need any particular skills?
Intermediate. You should have the skills to make the lamp base in your preferred material, as that is not covered in the course though obviously necessary to make a lamp. 
What do I get?
Three live sessions with questions and discussions, lasting about 90 minutes each week
Recordings of all sessions for later viewing on the course page
Downloadable PDFs of all presentations
A set of videos on the course page taking you through assembling, wiring and testing of lamps
Additional optional online course material, giving background info and greater depth
A discussion session where you can ask anything related to the course or related matters - the date and time will be scheduled so most students can participate, including those unable to attend the live sessions
Premium level access to the Tech part of my web site, containing much more information, references etc.
Course completion certificate

Tim Thornton

Lighting Design

Lampshade Making

Arts & Crafts

Want to make electric lamps, but not sure about the wiring, regulations and so on? If you can make the lamp base (in clay, wood, glass metal or whatever), then this course tells you how to do the rest.

Making Electric Lamps

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

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

2987 Link courses delivered Online

Inside an Artists mind Vibrant pig in Acrylics 48 mins

By Marilyn Allis

Inside an Artists mind Vibrant Lion in Acrylics 45 mins

By Marilyn Allis

Inside an Artists mind Vibrant Tiger in Acrylics 49mins

By Marilyn Allis

Marrakech Medina in watercolour 58mins

By Marilyn Allis

Vibrancy in Venice in watercolour 47mins

By Marilyn Allis

A winters day on the Cobb, Lyme Regis in watercolour

By Marilyn Allis

Spiritual Awakening Usui Reiki Lv1 Online

By Stephanie Edwards

Inside an Artists mind Vibrant Acrylics Red, Red wine 1 hour 32 mins

By Marilyn Allis

Inside an Artists mind Vibrant Bouzios Brazil Acrylics 1 hour 13 mins

By Marilyn Allis

Inside an Artists mind Vibrant Labrador in Acrylics 1 hour

By Marilyn Allis