Name: Career Developing Skills
Price: 18 GBP
Availability: InStock

<div fr-original-style="" style="box-sizing: border-box;">
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;">Mental Capacity Training</h2></div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
Have you ever wondered what happens when someone can&#39;t decide for themselves? Do you want to be one of those who helps people to overcome the complex stages of their life? Well, our Mental Capacity Training course will equip you with the knowledge and skills to navigate the complexities of mental capacity compassionately and ethically.This Mental Capacity Training course will enable you to apply the five principles of the MCA in practical scenarios to assess mental capacity, make informed decisions, and uphold individuals&#39; autonomy and best interests. Besides, you will learn the art of responsibly and effectively assessing mental capacity, including when and how to perform the functional test determining an individual&#39;s decision-making abilities. Furthermore, this Mental Capacity Training course will teach you how to safeguard vulnerable individuals effectively by understanding the responsible use of restraint and preventing ill-treatment and neglect. You will also gain in-depth knowledge of mental capacity assessment &amp; law. The last part of the Mental Capacity Training course focuses on Public Bodies and Services Created by MCA Act 2005. You will recognize the broader societal implications of this act and its role in shaping the care and treatment of individuals who lack capacity.Join us on this enlightening journey, and together, we&#39;ll unlock the doors to understanding and applying mental capacity law with empathy and precision.Mental Capacity Training&nbsp;Course Curriculum<ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Module 01: The Mental Capacity Act</li><li fr-original-style="" style="box-sizing: border-box;">Module 02: Assessment of Mental Capacity</li><li fr-original-style="" style="box-sizing: border-box;">Module 03: Best Interest Decision Making</li><li fr-original-style="" style="box-sizing: border-box;">Module 04: Advocacy and Advance Planning</li><li fr-original-style="" style="box-sizing: border-box;">Module 05: Providing Care or Treatment to People Who Lack Capacity</li><li fr-original-style="" style="box-sizing: border-box;">Module 06: Confidentiality and Record Keeping</li><li fr-original-style="" style="box-sizing: border-box;">Module 07: Mental Capacity Assessment &amp; Law</li><li fr-original-style="" style="box-sizing: border-box;">Module 08: Public Bodies and Services Created by MCA Act 2005</li></ul></div>
</div>
</div>
</div>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;">Why Choose Teachers Training</h2></div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
Some of our website features are:</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">


This is a dedicated website for teaching
</li>
<li fr-original-style="" style="box-sizing: border-box;">


24/7 tutor support
</li>
<li fr-original-style="" style="box-sizing: border-box;">


Interactive Content
</li>
<li fr-original-style="" style="box-sizing: border-box;">


Affordable price
</li>
<li fr-original-style="" style="box-sizing: border-box;">


Courses accredited by the UK&#39;s top awarding bodies
</li>
<li fr-original-style="" style="box-sizing: border-box;">


100% online 
</li>
<li fr-original-style="" style="box-sizing: border-box;">


Flexible deadline
</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;"> Entry Requirements
</h2></div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
No formal entry requirements. You need to have:</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">


Passion for learning
</li>
<li fr-original-style="" style="box-sizing: border-box;">


A good understanding of the English language
</li>
<li fr-original-style="" style="box-sizing: border-box;">


Be motivated and hard-working
</li>
<li fr-original-style="" style="box-sizing: border-box;">


Over the age of 16.
</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;">Assessment</h2></div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.&nbsp;After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate.</div>
</div>
</div>
</div>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;">Certification</h2></div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
CPD Certification from The Teachers TrainingSuccessfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">You can get your digital certificate (PDF) for &pound;4.99 only</li><li fr-original-style="" style="box-sizing: border-box;">Hard copy certificates are also available, and you can get one for only &pound;10.99</li><li fr-original-style="" style="box-sizing: border-box;">You can get both PDF and Hard copy certificates for just &pound;12.99!</li></ul>The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.</div>
</div>
</div>
</div>
</div>
</section>
</div>

The Teachers Training

Empower yourself with essential knowledge and skills in our Mental Capacity Training Course. Learn about assessing mental capacity, understanding legal frameworks, and making decisions on behalf of others. Gain insights into supporting individuals with impaired capacity in a respectful and ethical manner. Whether you're a healthcare professional, caregiver, or legal practitioner, this course provides valuable expertise in navigating complex issues surrounding mental capacity.

Mental Capacity Training

General Admission

TA Level 3: Teaching AssistantOur comprehensive TA Level 3: Teaching Assistant Course equips you with the essential skills and knowledge to thrive in the world of education.This TA Level 3: Teaching Assistant Course dives into the core competencies of a successful teaching assistant. You&rsquo;ll master key teaching assistant strategies that support cognitive development and foster essential reading, writing, speaking, and listening skills in students.Our TA Level 3: Teaching Assistant course also explores the professional standards expected of teaching assistants. Through the TA Level 3: Teaching Assistant Course, you&rsquo;ll gain a thorough understanding of personal and professional conduct, required knowledge, effective teaching and learning practices, and successful collaboration with colleagues. In our TA Level 3: Teaching Assistant course you&rsquo;ll learn the responsibilities of teaching assistants, including supporting students, teachers, the school itself, and the curriculum.Our TA Level 3: Teaching Assistant Course empowers you to provide differentiated support for each student, fostering their independent learning. You&rsquo;ll explore various school types within the Teaching Assistant Course and gain a clear understanding of their daily structures.Furthermore, this TA Level 3: Teaching Assistant Course equips you to effectively support students with special needs. You&rsquo;ll learn strategies to best support students with autism, ADHD, asthma, and other needs, ensuring an inclusive and enriching learning environment for everyone.By enrolling in our top-rated TA Level 3: Teaching Assistant Course, you&rsquo;ll gain the qualifications and confidence to launch a fulfilling career as a teaching assistant.TA Level 3: Teaching Assistant&nbsp; Course Curriculum<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Career Development &nbsp; &nbsp; &nbsp; &nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Introduction to Teaching Assistant &nbsp; &nbsp; &nbsp; &nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Skills of A Teaching Assistant &nbsp; &nbsp; &nbsp; &nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Strategies for A Teaching Assistant &nbsp; &nbsp; &nbsp; &nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Supporting Pupils with Special Needs Part 01 &nbsp; &nbsp; &nbsp; &nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Supporting Pupils with Special Needs Part 02 &nbsp; &nbsp; &nbsp; &nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">The Professional Standards for A Teaching Assistant &nbsp; &nbsp; &nbsp; &nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">The Role and Responsibilities of A Teaching Assistant &nbsp; &nbsp; &nbsp; &nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Working in the Classroom &nbsp; &nbsp; &nbsp; &nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Working in the School</li></ul>Who Is This TA Level 3: Teaching Assistant Course For?This TA Level 3: Teaching Assistant course is for anyone who wants to:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Enter a teaching profession</li><li fr-original-style="" style="box-sizing: border-box;">Get better in a teaching role</li><li fr-original-style="" style="box-sizing: border-box;">Add a qualification to their name</li><li fr-original-style="" style="box-sizing: border-box;">Teach the future generation and build them up</li><li fr-original-style="" style="box-sizing: border-box;">Gain leadership, presentation, and other valuable skills</li><li fr-original-style="" style="box-sizing: border-box;">What You Will Learn In This TA Level 3: Teaching Assistant Course</li><li fr-original-style="" style="box-sizing: border-box;">The skills to manage difficult behaviour</li><li fr-original-style="" style="box-sizing: border-box;">Develop your own teaching expertise</li><li fr-original-style="" style="box-sizing: border-box;">Presentation skills</li><li fr-original-style="" style="box-sizing: border-box;">Effective communication skills</li></ul>Career PathThis TA Level 3: Teaching Assistant course is for learners looking for career opportunities in the following professions:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Teaching Assistant</li><li fr-original-style="" style="box-sizing: border-box;">SEN Teaching Assistant</li><li fr-original-style="" style="box-sizing: border-box;">High school Teacher</li><li fr-original-style="" style="box-sizing: border-box;">Primary School Teacher</li><li fr-original-style="" style="box-sizing: border-box;">Private Tutor</li></ul>Why Choose Teachers TrainingSome of our website features are:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">This is a dedicated website for teaching</li><li fr-original-style="" style="box-sizing: border-box;">24/7 tutor support</li><li fr-original-style="" style="box-sizing: border-box;">Interactive Content</li><li fr-original-style="" style="box-sizing: border-box;">Affordable price</li><li fr-original-style="" style="box-sizing: border-box;">Courses accredited by the UK&#39;s top awarding bodies</li><li fr-original-style="" style="box-sizing: border-box;">100% online</li><li fr-original-style="" style="box-sizing: border-box;">Flexible deadline</li></ul>Entry Requirements For Teaching Assistant Level 3 DiplomaThere are no formal entry requirements for this Level 3: Teaching Assistant course. You need to have:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Passion for learning</li><li fr-original-style="" style="box-sizing: border-box;">A good understanding of the English language</li><li fr-original-style="" style="box-sizing: border-box;">Be motivated and hard-working</li><li fr-original-style="" style="box-sizing: border-box;">Over the age of 16.</li></ul>AssessmentThe assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of this TA Level 3: Teaching Assistant course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.&nbsp;After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate.CertificationCPD Certification from The Teachers TrainingAfter you have successfully completed your assignment, you will be qualified to apply for a CPD Certification from The Teachers Training. The PDF certificate can be downloaded after you have completed your course.<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">You can get your digital certificate (PDF) for &pound;4.99 only</li><li fr-original-style="" style="box-sizing: border-box;">Hard copy certificates are also available, and you can get one for only &pound;10.99</li><li fr-original-style="" style="box-sizing: border-box;">You can get both PDF and Hard copy certificates for just &pound;12.99!</li></ul>The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

Teacher Training

Support Assistant

Advance your career with our TA Level 3 Teaching Assistant Course. Gain essential skills and knowledge to excel in the classroom and support student success.

TA Level 3: Teaching Assistant

John Academy

Estate Agent

Legal Practice Course (LPC)

Bar Professional Training Course (BPTC)

Property Development

Trainers Course

Certificate in Mortgage Advice & Practice (CEMAP)

Property Developer and Estate Agent Diploma

Nutritional Therapist

Health & Nutrition

Nutrition Science

Nutritionist

Nutrition & Diet

Nutrition & Dietetics

Diet and Nutrition Practitioner Diploma

Office Skills & Productivity

Office Skills

Office Management

Workplace First Aid

Workplace Health & Safety

Office Administration

Complete Workplace Administration

<div>
	<h3>Course overview</h3>
Develop a comprehensive understanding of Organic Chemistry with this Organic chemistry demystified : 12H course + solved problems course. This course provides you with a simplified way of learning Organic Chemistry.
The Organic chemistry demystified : 12H course + solved problems training covers numerous solved problems to deepen your knowledge of Organic Chemistry fundamentals. It will provide you with step-by-step instructions on how to draw organic molecules and resonance structures. You will explore the nomenclature of Organic Chemistry and understand the concept of acid-base reactions in Organic Chemistry. In addition, you will identify what mechanisms are there in Organic Chemistry and gain the skills to solve various organic reactions.
Enroll right now and take steps to pursue a rewarding career in the field of Chemistry. 
<h3>Learning Outcomes</h3>
<ul>
<li>Be able to read and draw bond-line drawings</li>
<li>Learn how to draw resonance structures</li>
<li>Gain in-depth knowledge of the </li>
<li>Deepen your understanding of acid-base reactions</li>
<li>Learn the fundamentals of resonance </li>
<li>Identify the impact of resonance on geometry </li>
<li>Understand the nomenclature of Organic compounds</li>
<li>Learn about the various types of Organic reactions</li>
</ul>
<h3>Who Is This Course For?</h3>
This Organic chemistry demystified: 12H course + solved problems course helps aspiring professionals get started with Organic Chemistry by practicing various problems. Gaining the in-demand skills from this course offers excellent opportunities to pursue a rewarding career in the field of Chemistry. 
<h3>Entry Requirement</h3>
<ul>
<li>This course is available to all learners of all academic backgrounds.</li>
<li>Learners should be aged 16 or over.</li>
<li>Good understanding of English language, numeracy and ICT skills are required to take this course.</li>
</ul>
<h3>Certification</h3>
<ul>
<li>After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24.</li>
<li>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</li>
</ul>
<h3>Why Choose Us?</h3>
<ul>
<li>Affordable, engaging &amp; high-quality e-learning study materials;</li>
<li>Tutorial videos and materials from the industry-leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>United Kingdom &amp; internationally recognized accredited qualification;</li>
<li>Access to course content on mobile, tablet and desktop from anywhere, anytime;</li>
<li>Substantial career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path</h3>
The Organic chemistry demystified : 12H course + solved problems training provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as:
<ul>
<li>Chemist</li>
<li>Synthetic Organic Chemist</li>
<li>Group Leader-Organic Chemistry</li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Unit 01: About the Course</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 02: Drawing Organic Molecules</td>
				</tr>
								<tr>
					<td></td>
					<td>How to read bond-line drawings</td>
					<td> </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to draw bond-line drawings</td>
					<td> </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Identifying formal charges</td>
					<td> </td>
					<td> 00:22:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Finding lone pairs that are not drawn</td>
					<td> </td>
					<td> 00:23:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 03: Resonance</td>
				</tr>
								<tr>
					<td></td>
					<td>What is resonance?</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Drawing resonance structures (part 1)</td>
					<td> </td>
					<td> 00:40:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formal charges in resonance structures</td>
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Drawing resonance structures (part 2)</td>
					<td> </td>
					<td> 00:25:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Recognizing patterns</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The relative importance of resonance structures</td>
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 04: Acid-Base Reactions</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to acid - base</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Charged atoms</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Resonance</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Induction</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Orbitals</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Charged atoms - Resonance - Induction - Orbitals</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Showing an acid-base mechanism</td>
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Acid-Base equilibrium position</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 05: Geometry</td>
				</tr>
								<tr>
					<td></td>
					<td>Orbitals</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Goemetry of orbitals</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Impact of resonance on geometry</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 06: Nomenclature</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to nomenclature</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Functional group</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Unsaturation</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Parent</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Substituents</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>'cis' - 'trans' stereoisomerism</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>'E' - 'Z' stereoisomerism</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Localizing substituents in parent chain</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>From structure to name</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 07: Conformations</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to conformations</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Newman projection</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Relative stability of Newman projections</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Drawing chair conformations</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Drawing substituents in chair conformations</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Ring flipping</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Comparing stability of chair conformations</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 08: Configurations</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to configurations</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Locating stereocenters</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Determining the configuration of a stereocenter</td>
					<td> </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Nomenclature</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Enantiomers</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Diastereomers</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Meso compounds</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Fischer projections</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 09: Mechanisms</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to mechanisms</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Nucleophiles and electrophiles</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Arrows used for mechanisms</td>
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Carbocation</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 10: Substitution Reactions</td>
				</tr>
								<tr>
					<td></td>
					<td>SN1 SN2 mechanisms</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Factor #1: the electrophile</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Factor #2: the nucleophile</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Factor #3: the leaving group</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Factor #4: the solvent</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Combining all 4 factors</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 11: Elimination Reactions</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to elimination reactions</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>E1 mechanism</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>E2 mechanism</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 12: Substitution vs Elimination</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to substitution vs elimination</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Determining the function of the reagent</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Identifying the mechanism(s)</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Predicting regiochemical and stereochemical outcomes</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 13: Addition Reactions</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to addition reactions</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Regiochemistry</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Stereochemistry</td>
					<td> </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hydrogenation: adding H-H</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hydrohalogenation: adding hydrogen halide, H-X</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hydrobromination : adding H-Br</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hydration: adding H-OH</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Adding Br and Br</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Halohydrin formation: adding Br and OH</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>'Anti' dihydroxylation: adding OH and OH</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>'syn' dihydroxylation : adding OH and OH</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Ozonolysis</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Reactions summary</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 14: Synthesis Techniques</td>
				</tr>
								<tr>
					<td></td>
					<td>One-step synthesis</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Combining reactions: changing the position of a leaving group</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Combining reactions: changing the position of a double bond</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Combining reactions: introducing functionality</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 15: Wrapping Up and Bonus</td>
				</tr>
								<tr>
					<td></td>
					<td>Thank you for enrolling and announcing part 2</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

Online Course Marketing

Higher Chemistry

Organic chemistry demystified : 12H course + solved problems

<div>
	Course Overview
Learn all the essential skills to become an expert in Therapy. From this comprehensive Aromatherapy Advanced Diploma course, you will be able to understand the principles of Therapy. In the step-by-step training process, you will acquire practical skills along with theoretical knowledge. The Qualified professionals will assist you throughout this learning process.
 
This Aromatherapy Advanced Diploma is structured to ensure you have all the adequate skills to secure a position in this competitive industry. You will achieve the confidence and competency to bear all the responsibilities of this profession. The course will add all the right credentials to your resume and increase your employability in this growing industry.
 
Who is this course for?
Anyone who is now employed in this field or who aspires to be one should take this course. Your knowledge will grow through taking this course, which will also strengthen your resume. To demonstrate your newly gained knowledge, develop crucial abilities and receive a professional credential.
Entry Requirement
<ul>
<li>This course is available to all learners, of all academic backgrounds.</li>
<li>Learners should be aged 16 or over to undertake the qualification.</li>
<li>Good understanding of English language, numeracy and ICT are required to attend this course.</li>
</ul>
Certification
<ul>
<li>After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24.</li>
<li>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</li>
</ul>
Why choose us?
<ul>
<li>Affordable, engaging &amp; high-quality e-learning study materials;</li>
<li>Tutorial videos/materials from the industry-leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>The UK &amp; internationally recognized accredited qualification;</li>
<li>Access to course content on mobile, tablet or desktop from anywhere anytime;</li>
<li>The benefit of career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
Career Path
The Aromatherapy Advanced Diploma course is intended to assist you in obtaining the dream job or maybe the promotion you've always desired. With the assistance and direction of our Aromatherapy Advanced Diploma course, learn the vital abilities and knowledge you require to succeed in your life.
 
 
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Module: 01</td>
				</tr>
								<tr>
					<td></td>
					<td>Welcome to my course</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Before we start</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What is aromatherapy?</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Where do plants have essential oils?</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Why does the cost of essential oils vary so much?</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What to look for when buying essential oils</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How essential oils can be adulterated</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>I just bought some adulterated essential oils</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Storing your essential oils</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Best carrier oils for skin conditions and small areas</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dilution rates</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What are think are the best carrier oils for massage</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What on earth do these words mean?</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 02</td>
				</tr>
								<tr>
					<td></td>
					<td>If I only had lavender oil, what can I do with it?</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>A quick word about using lavender oil neat</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating bites and stings with lavender</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lots of great ways to use lavender in your daily life</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 03</td>
				</tr>
								<tr>
					<td></td>
					<td>How does aromatherapy affect our minds and bodies?</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What is the quickest base to get the oils absorbed into our bloodstreams?</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to increase your absorption rate even more</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The garlic test</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 04</td>
				</tr>
								<tr>
					<td></td>
					<td>What you will learn in this section</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Steam and Water Distillation process</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Cold expression</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Solvent extraction</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Carbon dioxide extraction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Enfleurage</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Summary</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 05</td>
				</tr>
								<tr>
					<td></td>
					<td>Using essential oils safely is paramount</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Some Good News For People With High Blood Pressure</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dealing with poisoning and skin reactions</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>A word about using citrus oils and photosensitivity</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Oils that must be avoided in pregnancy and nursing mothers</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What you should not do</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 06</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to the ways to apply your aromatherapy</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>A Word About Aromatherapy Baths</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Warm and Cold Compresses</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Roller Balls</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bath and body products</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Small topical creams, oils and lotions</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Foot Baths</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Steam Inhalation</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Diffusers/inhalation</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Full body massage</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Room sprays</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>To summarize the best ways to apply aromatherapy for the various conditions</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 07</td>
				</tr>
								<tr>
					<td></td>
					<td>What we are going to go through from now on</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Let's take a look at stress</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>A Handy List Of essential Oils For Emotional States</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Stress and insomnia-which oils to use</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What some studies say about helping anxiety and depression</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Let's use this knowledge in a practical situation</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 08</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to treat acute injuries</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to treat chronic pain</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Headaches</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to treat arthritis</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>If I had just 1 essential oil to treat pain with, it would be this one</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>A 2018 Study on Knee Osteoarthritis Pain Using Lavender</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>A Study that increased Athletic Performance With Aromatherapy</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bruises</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Varicose veins</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 09</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating swelling, edema and cellulite</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 10</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating Respiratory Disorders</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating Sinusitis</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating Asthma</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating Chronic Bronchitis</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating Hayfever</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating allergies with the big 4 essential oils</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 11</td>
				</tr>
								<tr>
					<td></td>
					<td>Digestive disorders in general</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating nausea</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating Irritable Bowel Syndrome (IBS)</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating Constipation</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating Weight Loss</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 12</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating Dysmenorrhea (painful periods)</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating PMS</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating Menopause</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 13</td>
				</tr>
								<tr>
					<td></td>
					<td>In general</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>A Handy List Of essential Oils For Skin Types</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Treating Dermatitis/Eczema</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Studies on using sandalwood for eczema and psoriasis</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Psoriasis</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Using tea tree for acne</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hair loss and scalp issues</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Burns</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Athletes foot</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Scars</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Wrinkles/anti-aging</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Make your own anti-aging serum</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Stretch marks oil</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hand sanitizer spray</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Congratulations!</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

Perfume Making

Beauty Therapist

Medical Herbalist

Aromatherapy

Essential Oils

Aromatherapy Advanced Diploma

<div>
	<h3>Course overview</h3>
Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA &amp; Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query.
This Advanced Excel Models using Formulas, VBA &amp; Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations.  We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula.
<h3>Learning outcomes</h3>
<ul>
<li>Familiarize yourself with the advanced Excel formulas</li>
<li>Be able to manage prepaid expenses</li>
<li>Deepen your understanding of the prepaid expense models</li>
<li>Learn about the pro Excel models and formulas</li>
<li>Strengthen your knowledge of Power Query and PowerPivot</li>
<li>Learn how to create Power query and pivot table based dashboard without any formula</li>
</ul>
<h3>Who Is This Course For?</h3>
This  Advanced Excel Models using Formulas, VBA &amp; Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement.
<h3>Entry Requirement</h3>
<ul>
<li>This course is available to all learners of all academic backgrounds.</li>
<li>Learners should be aged 16 or over.</li>
<li>Good understanding of English language, numeracy and ICT skills are required to take this course.</li>
</ul>
<h3>Certification</h3>
<ul>
<li>After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24.</li>
<li>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</li>
</ul>
<h3>Why Choose Us?</h3>
<ul>
<li>Affordable, engaging &amp; high-quality e-learning study materials;</li>
<li>Tutorial videos and materials from the industry-leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>United Kingdom &amp; internationally recognized accredited qualification;</li>
<li>Access to course content on mobile, tablet and desktop from anywhere, anytime;</li>
<li>Substantial career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path</h3>
The Advanced Excel Models using Formulas, VBA &amp; Power Query Course provides  essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as:
<ul>
<li>Data Analyst</li>
<li>System Support and Reporting Analyst</li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>Course Outline and Introduction</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Minimum Requirements for the Course</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Prepayments Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Prepaid Expenses Models: Resources Download</td>
				</tr>
								<tr>
					<td></td>
					<td>Month End Date Prepaid Expenses Amortization Calculation</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Exact Prepaid Expenses Payment Date Calculation</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Accounting for Prepaid Expenses</td>
				</tr>
								<tr>
					<td></td>
					<td>Prepaid Expenses Accounting Definition: Prepayments</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Prepaid Expense Example: How Accounting works for Prepayments</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advantages and Disadvantages of Prepaid Expenses</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Excel Formulas Detailed: Introduction to three Excel Models</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to PRO Excel Models and Formulas</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Date Function</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>EOMONTH Function</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>DATEVALUE function</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IF Function</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IFS Function (Office 365 Only)</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>VLOOKUP Function</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>MATCH Function</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>INDIRECT Function</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>NAMED Ranges: Name Manager</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advanced Version of VLOOKUP Function</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Formula Based Prepaid Expenses Model</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to Model and Control Panel Tab (Important Sheet Tab)</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formula Based Prepaid Expenses Model - Deep Dive (Part 1)</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formula Based Prepaid Expenses Model - Deep Dive (Part 2)</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formula Based Prepaid Expenses Model - Deep Dive (Part 3)</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IFS Function - Month End date Prepayment calculation</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary)</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Protecting Formulas Cells and Fields in the Model</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Calculate Prepaid Expenses Amortisation from Exact Start Date</td>
				</tr>
								<tr>
					<td></td>
					<td>Exact Date Prepaid Amortisation calculation Intro</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formulas update and Model Changes for Exact Prepaid Exps Calculation</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1)</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2)</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3)</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4)</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IFS Function - Exact Date Prepayments Amortisation</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Validation Controls (Enhancing Data Input Controls with Protection)</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus: Prepayment Model with Opening Balance Calculation (Part 1)</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus: Prepayment Model with Opening Balance Calculation (Part 2)</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Additional Material: Resources</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Prepaid Expenses Summary with Power Query and Pivot Table</td>
				</tr>
								<tr>
					<td></td>
					<td>Power Query and Pivot Table Prepayment Summary Table Intro</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What is Power Query and Some Awesome Resources for Power Query learning</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Power Query and Pivot Table Summary - Deep Dive (Part 1)</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Power Query and Pivot Table Summary - Deep Dive (Part 2)</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Power Query and Pivot Table Summary - Deep Dive (Part 3)</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Power Query and Pivot Table Summary - Deep Dive (Part 4)</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Using Array Formulas to Add Formula Protection</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version)</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td colspan="4">Advanced VBA Prepaid Expenses Amortisation Model</td>
				</tr>
								<tr>
					<td></td>
					<td>Changing Macros Security in Excel</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus : New Version - Excel VBA Model for Prepayment Expenditure</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way</td>
				</tr>
								<tr>
					<td></td>
					<td>Dynamic Dashboard Overview</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Importing Profit and Loss Statements Source Files and creating YTD P&amp;L Sheets</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Dynamic Data Validation</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Named Ranges for Dynamic Table Arrays</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dynamic Date Column Headings for each Divisional PL Table</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dynamic Month and YTD Dashboard tables headings (PRO TIP)</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dynamic VLOOKUP Formula - Preparing First section of the Dashboard</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Rolling Dashboard with Dynamic VLOOKUP Function</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP)</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function)</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1)</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2)</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Power Query &amp; Pivot Tables based Dashboard without any Formulas, Fully Dynamic</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Understanding the data files before building dashboard</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Consolidating Reports with Power Query (Get &amp; Transform) , How to install PQ</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dynamic File Path Trick in Power Query with Parameters (Amazing trick)</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Conditional Cumulative totals with SUMIFS Function</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code)</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast)</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Dashboard Creation - Line Charts</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Update Dashboard with Additional Divisional Data with Few Click (Magical)</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Thankyou</td>
				</tr>
								<tr>
					<td></td>
					<td>Thank you</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Ultimate Prepaid Expenditure Model (Super Bonus)</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Resources</td>
				</tr>
								<tr>
					<td></td>
					<td>Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

Financial Modelling & Analysis

Finance Cert & Exam Prep

Financial Modelling

Excel Analytics

Microsoft Excel

Practical Accounting

Advanced Excel Models using Formulas, VBA & Power Query

<div>
	<h3>Course Overview</h3>
Find the ultimate guide for learning Django framework by taking this Django REST Framework - Full Stack Python APIs using Python course. In this course, you will learn the techniques to build Python Rest APIs using the Django framework.
This Django REST Framework - Full Stack Python APIs using Python course breaks tools and techniques to enhance your understanding of the Django framework and its features. The project-based course provides step-by-step instructions on how to create a Rest API from scratch. You will start the course by learning how to set up a Django development environment and proceed towards the fundamental steps in creating a Rest API project. You will gain the knowledge to develop Rest APIs using function-based views and class-based views. You will also learn the best practices to secure your Rest APIs.
<h3>Learning Outcomes</h3>
<ul>
<li>Gain in-depth knowledge Rest API</li>
<li>Learn hope to configure the Rest API</li>
<li>Identify the importance of Django Framework</li>
<li>Deepen your understanding of  mixins and generic views</li>
<li>Know how to create Rest APIs using function based views</li>
<li>Learn how to create viewset</li>
<li>Be able to create Rest APIs with class based views</li>
</ul>
<h3>Who Is This Course For?</h3>
The Django REST Framework - Full Stack Python APIs using Python course is incredibly beneficial for professionals interested in learning how to create Python Rest APIs in Django Framework. 
<h3>Entry Requirement</h3>
<ul>
<li>This course is available to all learners of all academic backgrounds.</li>
<li>Learners should be aged 16 or over.</li>
<li>Good understanding of English language, numeracy and ICT skills are required to take this course.</li>
</ul>
<h3>Certification</h3>
<ul>
<li>After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24.</li>
<li>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</li>
</ul>
<h3>Why Choose Us?</h3>
<ul>
<li>Affordable, engaging &amp; high-quality e-learning study materials;</li>
<li>Tutorial videos and materials from the industry-leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>United Kingdom &amp; internationally recognized accredited qualification;</li>
<li>Access to course content on mobile, tablet and desktop from anywhere, anytime;</li>
<li>Substantial career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path</h3>
Django REST Framework - Full Stack Python APIs using Python provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as
<ul>
<li>Full Stack- Lead Software Developer</li>
<li>Python/Django Developer</li>
<li>Backend Developer </li>
<li>Software Engineer-Python</li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Unit 01: Start Here</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Course and Instructor Introduction</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: How to make the best of this course</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 02: Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: What is REST?</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Why REST</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: What and Why DJango REST Framework</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 03: Software Setup</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Install DJango</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Install DJango REST Framework</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Install MySql and MySql workbench</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: Launch MySql workbench</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 05: Install python mysqlclient</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 06: Install ATOM</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 07: Install Postman</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 04: REST in Action</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Create the Project</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Create a view</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Configure the URL and TEST</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: Create app level urls</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 05: Create a model class</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 06: Configure the database and run migrations</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 07: Use the model in the view and test</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 05: Function Based Views and Serializers</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: DRF Components</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Function Based Views</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Serializers</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: Create the Project</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 05: Create the Model</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 06: Create the Serializer</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 07: GET single student</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 08: Create Student</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 09: Implement Non Primary Key Based Operations</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 10: Use @api_view</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 11: Configure the URLs</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 12: Test</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 13: Test Using Postman</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 06: Class Based Views</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Introduction</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Create the Project</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Implement Non Primary Key Based Operations</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: Implement Primary Key Based Operations</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 05: Configure the URLs and TEST</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 07: Mixins</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Introduction</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Non Primary Key based operations</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Primary Key based operations</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: Configure the URLs and TEST</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 08: Generic Views</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Generics</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Generics in action</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 09: ViewSets</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Introduction</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Create ViewSet</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Configure URLs and Test</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 10: Nested Serializers</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Create the project</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Create model</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Create Serializers</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: Create REST endpoints</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 05: Configure URLs</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 06: Test</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 11: Pagination</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Introduction</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Pagination in action</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Pagination at class level</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: Using LimitOffsetPagination</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 12: Security</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Introduction</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Authentication in action</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Authorization in action</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: Global Security</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 13: Flight Reservation API</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Usecase</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Create the Project</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Create Model Classes</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: Create Reservation Model</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 05: Create Serializers</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 06: Create ViewSets</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 07: Configure the Router</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 08: Run Migrations</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 09: Initial round of testing</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 10: Implement findFlights endpoint</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 11: Test findFlights</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 12: Implement Save Reservation</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 13: Test Save Reservation</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 14: Validations</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: In-Built Validations</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Allowing Blank and Null Values</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Create Custom Validator</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: Two more ways</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Unit 15: Token Auth</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Introduction</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Configure Token Auth</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Create Users and Token</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: Token Auth in action</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 05: Automate Token Creation</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

Online Course Creation

Django REST Framework - Full Stack Python APIs using Python

<div>
	<blockquote> Do you want to be able to develop your skills and at the same have a career growth?  If so, then this course will be perfect for you and your needs.</blockquote>
<h3>Description: </h3>
Do you always feel burned out because of work? Are you feeling that you are stuck with your work and being burdened by it? If you are feeling like this, then this course will help you learn the necessary skills you need for career development. You will also be educated on the skills where you need improvement and help you taking assessment tests for your chosen career. This course will also help you in getting help through mentoring and taking online and offline classes. This course will also teach you valuable life lessons and the importance of esteem for career development.
<h3>Who is the course for?</h3>
<ul>
<li>Professionals or anyone who helps people with their dilemmas in career development.</li>
<li>People who have an interest in developing their career developing skills.</li>
</ul>
<h3>Entry Requirement:</h3>
<ul>
<li>This course is available to all learners, of all academic backgrounds. </li>
<li>Learners should be aged 16 or over to undertake the qualification.</li>
<li>Good understanding of English language, numeracy and ICT are required to attend this course.</li>
</ul>
<h3>Assessment: </h3>
<ul>
<li>At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.</li>
<li>Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.</li>
</ul>
<h3>Certification:</h3>
<ul>
<li>After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.</li>
<li>PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days.</li>
</ul>
<h3>Why choose us?</h3>
<ul>
<li>Affordable, engaging &amp; high-quality e-learning study materials;</li>
<li>Tutorial videos/materials from the industry leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>The UK &amp; internationally recognised accredited qualification;</li>
<li>Access to course content on mobile, tablet or desktop from anywhere anytime;</li>
<li>The benefit of career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path:</h3>
The Career Developing Skills would be beneficial for the following careers:
<ul>
<li>Career Coaches</li>
<li>Human Resource Specialist</li>
<li>Human Resource Managers</li>
<li>Life Coaches</li>
<li>Managers</li>
<li>Mentors</li>
<li>Top Executives.</li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Career Developing Skills</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Ways To Improve Your Performance At Work</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Career Aptitude Tests And Career Assessments</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Get Mentoring</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Importance Of Online Courses</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advantages To Take Offline Courses</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Benefits Of Life Lessons</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Self Esteem</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td colspan="4"> Professional CV &amp; Resume Writing Techniques</td>
				</tr>
								<tr>
					<td></td>
					<td>INTRODUCTION</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>EFFECTIVE RESUME AND COVER LETTER WRITING</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>THE PURPOSE OF YOUR RESUME</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>RESUME PRESENTATION IS THE KEY</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WOW THE EMPLOYER</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>ELEMENTS OF A RESUME THAT WILL IMPRESS</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING YOUR OBJECTIVE</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING YOUR SUMMARY</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING THE SKILLS AND ACCOMPLISHMENTS SECTION</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>RESUME FORMATTING</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING AN ELECTRONIC RESUME</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>PUT YOUR BEST FOOT FORWARD</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>YOUR RESUME - A WORK OF ART</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING THE HISTORY/ EXPERIENCE SECTION</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING YOUR EDUCATION SECTION</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING A PROFESSIONAL AFFILIATIONS SECTION</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING A PUBLICATIONS and PERSONAL INTERESTS SECTION</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>WRITING A REFERENCES SECTION</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>YOUR RESUME - A WORK OF ART</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>DO NOT PUT IN YOUR RESUME</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>A VARIETY OF RESUME SAMPLES</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>THE IMPORTANCE OF WRITING COVER LETTERS</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>COVER LETTER OUTLINE: HOW TO WRITE A GOOD COVER LETTER</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>KEY PHRASES TO BE USED IN YOUR COVER LETTER</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>COVER LETTER SAMPLE</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>BASIC COVER LETTER TEMPLATE EXAMPLE</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>CONCLUSION</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4">How to Face an Interview Successfully</td>
				</tr>
								<tr>
					<td></td>
					<td>Importance of Knowing The Tips And Tricks for Interviews</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Different Types of Interviews</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Skill Building to Crack Interviews</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Tools and Miscellaneous You Need To Have</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Perfect 'Resume' - Significance and Importance</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Preparing Properly for an Interview</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What Role Does Appearance Play?</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Tips To Gear Up - Pre-Interview</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Modern Tips By Interview Experts</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Word</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Your First Document</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Basic Editing Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Basic Formatting Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Formatting Paragraphs</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Advanced Formatting Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Working with Styles</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Formatting the Page</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Sharing Your Document</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft PowerPoint</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening PowerPoint</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Your First Presentation</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Working with Text</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Formatting Text and Paragraphs</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Adding Pictures</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Advanced Formatting Tasks</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Working with Transitions and Animations</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Setting Up Your Slide Show</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Showtime!</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Microsoft Excel</td>
				</tr>
								<tr>
					<td></td>
					<td>Module One - Getting Started</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Two - Opening Excel</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Three - Working with the Interface</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Four - Your First Worksheet</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Five - Viewing Excel Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Six - Building Formulas</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Seven - Using Excel Functions</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eight - Using Quick Analysis</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Nine - Formatting Your Data</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Ten - Using Styles, Themes, and Effects</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Eleven - Printing and Sharing Your Workbook</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module Twelve - Wrapping Up</td>
					<td> </td>
					<td> 01:00:00</td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam </td>
				</tr>
								<tr>
					<td></td>
					<td>Mock Exam- Career Developing Skills</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Final Exam- Career Developing Skills</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
				</tbody></table>

Learning & Development

Professional Skills

Career Development

Employability Skills

Professional Skills Course (PSC)

Resume & CV Writing

Career Developing Skills

<div id="course-pills-1">Duration5 Days30 CPD hoursThis course is intended forThis course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.OverviewCreate single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queriesThis five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.Prerequisites<ul> <li>Basic understanding of relational databases.</li> <li>Basic Windows knowledge.</li> </ul></div><div id="course-pills-2"><h3>Module 1: Introduction to Transact-SQL</h3><ul> <li>What is Transact-SQL</li> <li>The SELECT statement</li> <li>The WHERE clause</li> <li>Sorting results</li> <li>Calculations</li> <li>CASE expressions</li> </ul> <h3>Module 2: Joining tables with Transact-SQL</h3><ul> <li>The JOIN clause</li> <li>Inner joins</li> <li>Outer joins</li> <li>Self joins and cross joins</li> </ul> <h3>Module 3: Filtering and sorting results</h3><ul> <li>Implement the ORDER BY clause</li> <li>Filter data with the WHERE clause</li> <li>Limit the number of rows returned by a query</li> <li>Implement NULL logic</li> </ul> <h3>Module 4: SQL Server data types</h3><ul> <li>Understand data types</li> <li>Implement string data types</li> <li>Implement temporal data types</li> </ul> <h3>Module 5: Inserting, updating and deleting data</h3><ul> <li>Insert new records</li> <li>Update existing records</li> <li>Delete data</li> </ul> <h3>Module 6: Using SQL Server functions with Transact-SQL</h3><ul> <li>Understand function types in SQL Server</li> <li>Convert data using functions</li> <li>Implement logical functions</li> <li>Work with NULL data using functions</li> </ul> <h3>Module 7: Aggregating data with Transact-SQL</h3><ul> <li>Implement aggregation in SQL Server</li> <li>Group records in SQL Server</li> <li>Filter aggregated data</li> </ul> <h3>Module 8: Implement subqueries with Transact-SQL</h3><ul> <li>Implement scalar and multi-valued sub-queries</li> <li>Implement correlated subqueries</li> <li>Implement existence checks with subqueries</li> </ul> <h3>Module 9: Create queries that use table expressions</h3><ul> <li>Create views</li> <li>Create table-valued functions</li> <li>Implement derived tables</li> <li>Implement common table expressions</li> </ul> <h3>Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data</h3><ul> <li>Write queries with the UNION operator</li> <li>Write queries with the INTERSECT and EXCEPT operators</li> <li>Write queries with the APPLY operator</li> </ul> <h3>Module 11: Implement window functions in queries</h3><ul> <li>Understand window functions</li> <li>Impement window functions</li> </ul> <h3>Module 12: Use PIVOT and grouping sets in queries</h3><ul> <li>Implement PIVOT in queries</li> <li>Implement grouping sets in queries</li> </ul> <h3>Module 13: Use stored procedures in queries</h3><ul> <li>Query data with stored procedures</li> <li>Interact with stored procedures using input and output parameters</li> <li>Write simple stored procedures</li> <li>Pass dynamic SQL to SQL Server</li> </ul> <h3>Module 14: Implement programming features in Transact-SQL</h3><ul> <li>Understand T-SQL programming elements</li> <li>Implement loops and conditions in T-SQL queries</li> </ul> <h3>Module 15: Add error handling to queries</h3><ul> <li>Understand SQL Server error handling</li> <li>Implemet structured exception handling</li> </ul> <h3>Module 16: Use transactions in queries</h3><ul> <li>Understand database transactions</li> <li>Implement transactions in T-SQL</li> </ul></div>

Nexus Human

Computing Skills

Microsoft SQL

Data Skills

SQL Server

55366 Querying Data with Transact-SQL

Bournemouth

London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

Discernment Formation for Course Leaderswith Rachel Overton and Nick HelmThis programme aims to enable course leaders to develop or sharpen up discernment processes within formation programmes for spiritual directors from all traditions.&nbsp;A previous participant says:&#39;This programme really helped me to find a language with which to fully&nbsp;understand discernment processes for myself and for my facilitating the development of others.&rsquo;&nbsp;Discernment is not something that we &lsquo;do&rsquo; at certain moments of decision in life.&nbsp;&nbsp;Rather it is the stance we should assume in every aspect of life and can be articulated in the question &lsquo;how am I centred and responsive to God?&rsquo;As course leaders and people responsible for the formation of spiritual directors, we need to be aware of our own discernment processes if we are to enable others to grow in their ability to discern well.&nbsp;&nbsp;Such awareness also enables us to offer congruence between the formation programme we are a part of, the nature of spiritual accompaniment and being faithful to God in life.&nbsp; &nbsp;Over the course of the four day sessions, we will enable participants to engage with questions such as:&nbsp;<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">What do you pay attention to within your own experience?&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Why do you pay attention to that?&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">How do you respond to what you notice?</li><li fr-original-style="" style="box-sizing: border-box;">What choices do you make?</li><li fr-original-style="" style="box-sizing: border-box;">How does all of this apply to you personally, your role as a spiritual director and your role in the formation of spiritual directors.</li></ul>&nbsp;These will be explored in relation to the &lsquo;triangle model&rsquo; of relationships within spiritual direction &ndash; a model which helps to sharpen awareness of the multiple aspects of discernment that we need to pay attention to.The programme will be experiential, involving small group work as well as plenary sessions. &nbsp;Participants will also be expected to take time to reflect and continue to work with their own process in between sessions.By the end of the programme, participants can expect to:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">be more aware of their own process and language of discernment</li><li fr-original-style="" style="box-sizing: border-box;">have greater awareness of how discernment is lived in spiritual direction and spiritual direction formation</li><li fr-original-style="" style="box-sizing: border-box;">be more secure in their role as a trainer enabling discerning processes</li><li fr-original-style="" style="box-sizing: border-box;">have clarity about ways in which this discerning stance can be developed in the course they are involved in</li></ul>All sessions will run on Zoom from 9.45am to 4.15pm<div fr-original-style="" style="box-sizing: border-box;"> </div>Previous participants share their responses to this programme:&nbsp;&lsquo;A safe space to open your heart to the unexpected.&rsquo;&lsquo;It opens up the process of discerning far better than reading it in a book.&#39;&lsquo;[It] may well change your perception of what discernment is all about and, with practice, it will change the way you live and pray. I would thoroughly recommend this learning process and experience.&rsquo;&lsquo;Approach with an attentive, open heart, recognising the potential to go deeper through exploring discernment by journeying both as individual and with others.&rsquo;&lsquo;A very in-depth programme that really gets to the heart of discernment. Don&rsquo;t miss it - it can change your life!!&rsquo;&lsquo;It wasn&#39;t until I experienced this programme with Nick and Rachel that it became obvious how vital this clarification of, and approach to discernment is, and would whole-heartedly recommend this empowering course to the most seasoned of trainers as well as those just starting out.&rsquo;

Discernment Formation for Course Leaders
with Rachel Overton and Nick Helm
This programme aims to enable course leaders to develop or sharpen up discernment processes within formation programmes for spiritual directors from all traditions. 
A previous participant says:
'This programme really helped me to find a language with which to fully understand discernment processes for myself and for my facilitating the development of others.’ 
Discernment is not something that we ‘do’ at certain moments of decision in life. Rather it is the stance we should assume in every aspect of life and can be articulated in the question ‘how am I centred and responsive to God?’
As course leaders and people responsible for the formation of spiritual directors, we need to be aware of our own discernment processes if we are to enable others to grow in their ability to discern well. Such awareness also enables us to offer congruence between the formation programme we are a part of, the nature of spiritual accompaniment and being faithful to God in life. 
Over the course of the four day sessions, we will enable participants to engage with questions such as: 
What do you pay attention to within your own experience?
Why do you pay attention to that?
How do you respond to what you notice?
What choices do you make?
How does all of this apply to you personally, your role as a spiritual director and your role in the formation of spiritual directors.
 These will be explored in relation to the ‘triangle model’ of relationships within spiritual direction – a model which helps to sharpen awareness of the multiple aspects of discernment that we need to pay attention to.
The programme will be experiential, involving small group work as well as plenary sessions. Participants will also be expected to take time to reflect and continue to work with their own process in between sessions.
By the end of the programme, participants can expect to:
be more aware of their own process and language of discernment
have greater awareness of how discernment is lived in spiritual direction and spiritual direction formation
be more secure in their role as a trainer enabling discerning processes
have clarity about ways in which this discerning stance can be developed in the course they are involved in
All sessions will run on Zoom from 9.45am to 4.15pm
Previous participants share their responses to this programme: 
‘A safe space to open your heart to the unexpected.’
‘It opens up the process of discerning far better than reading it in a book.'
‘[It] may well change your perception of what discernment is all about and, with practice, it will change the way you live and pray. I would thoroughly recommend this learning process and experience.’
‘Approach with an attentive, open heart, recognising the potential to go deeper through exploring discernment by journeying both as individual and with others.’
‘A very in-depth programme that really gets to the heart of discernment. Don’t miss it - it can change your life!!’
‘It wasn't until I experienced this programme with Nick and Rachel that it became obvious how vital this clarification of, and approach to discernment is, and would whole-heartedly recommend this empowering course to the most seasoned of trainers as well as those just starting out.’

SoulSpark Online

Spiritual Direction

Training Trainers of Spiritual Directors
Developing the abilities needed to facilitate Spiritual Direction formation programmes

Catching the Wind

The colour energies are the essential building blocks of team and personal effectiveness, they develop the vital self awareness that makes flexibility possible.Being flexible is the key to building effective and productive relationships.&nbsp; Adapting your style to connect with the style of your customer will lead to greater rapport.&nbsp; With rapport you can begin to influence your customer.This virtual workshop has been designed for any group of people who want to learn how to build rapport quickly with lots of customers and other key stakeholders.Our Building Influence &amp; Selling Skills Workshop is an interactive, informative and fun way to begin this journey. We focus on behaviours rather than personality and provide a common language that helps individuals identify how to flex their style and create stronger connections.How will your team benefit from this workshop? They will:✔ &nbsp; &nbsp;Understand individual strengths and potential development needs in this area✔ &nbsp; &nbsp;Explore effective sales and influencing techniques for different audiences✔ &nbsp; &nbsp;Optimise communication with stakeholders✔ &nbsp; &nbsp;Consider how body language as well as written and verbal communication styles can influence this area✔ &nbsp; &nbsp;Understand different clients&#39; drivers and blockers✔ &nbsp; &nbsp;Learn ways to practically apply these concepts to current situations and clientsWe have worked with thousands of teams and individuals, which statement best describes your team:<ul style="list-style-type: disc; box-sizing: border-box;" fr-original-style="list-style-type: disc;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Inexperienced</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Want to develop pitching &amp; presenting skills</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Not hitting targets</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Looking to improve results</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Would benefit from sales skills development</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Influencing others regularly</li></ul>Take advantage of our add-on offers at the checkout and enhance your experience on this workshop.&nbsp; Buy a set of <a href="https://colour-energies.com/colour-energies-building-blocks/" 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;">Colour Energies Building Blocks</a> and/or a <a href="https://colour-energies.com/colour-energies-card-game/" 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;">Colour Energies Card Game</a> and see how easily you can embed the colour energies in your team.Act Now! Contact us to bring the world of the colour energies to your team and experience the benefit of a common language that will drive your performance to a higher level.<a href="https://colour-energies.com/" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;">Get in touch</a>

colour-energies.com

Disc

Team Building

Professional Selling Skills (PSS)

Business Leadership

Relationship Building

Insights

Influence Skills

Insights Discovery

The four colour energies will transform your teams ability to influence customers and tailor their approach to different customers preferences.  By building deep rapport and creating trust your customers will strengthen their bond with your organisation.  Watch as your sales and profits exceed your expectations.

The 4 Colour Energies - Building Influence & Selling Skills

Early Bird Offer

Buy a place and get a second place for 50% discount

Buy One place get a second half price

An Introduction to Medical Terminology short course delivered online via Teams, suitable for anyone wishing to learn the basics of terminology. Dates of courses can be seen when clicking &lsquo;register&rsquo; below. <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;">Level One &ndash; Introduction to Medical Terminology.<blockquote style="color: rgb(103, 106, 108); border-left: 2px solid rgb(94, 53, 177); margin-left: 0px; padding-left: 5px; box-sizing: border-box;" fr-original-style=" color: rgb(103, 106, 108);">&ldquo;It&#39;s like a light has just been switched on and I now understand more of what I&#39;m doing!&rdquo; &ndash; Feedback from attendee of Level one course.</blockquote>This course is aimed at anyone who requires a knowledge of medical terminology in their role. It is suitable for administrative staff, health care workers, medical secretaries, managers, Allied Health Professionals, essentially anyone who may encounter medical terminology and wishes to develop their medical terminology knowledge further. We also offer sessions to those requiring an overview of medical terminology to support applications to study medicine, veterinary medicine or dentistry. We can train between 1-30 learners from any organisation. If you have a specific training request, please speak to us and we can accommodate your needs. We recently trained a group of sign language interpreters who found the training invaluable when working in medical environments. The sessions are delivered via Teams (2x 2 hour meetings) so are highly accessible, a webcam and microphone are required although not essential. The aim of the course is for learners to develop an understanding of medical terminology in an enjoyable, interactive and informative way so that they are better able to decipher and unravel the mystery of long medical words. The course covers the following topics:- <ul style="color: rgb(103, 106, 108); box-sizing: border-box;" fr-original-style=" color: rgb(103, 106, 108);"><li fr-original-style="" style="box-sizing: border-box;">Basics of medical terminology &ndash; word building</li><li fr-original-style="" style="box-sizing: border-box;">Common Roots, prefixes and suffixes</li><li fr-original-style="" style="box-sizing: border-box;">Anatomy and physiology via a virtual tour of the body</li><li fr-original-style="" style="box-sizing: border-box;">Major bones of the body</li><li fr-original-style="" style="box-sizing: border-box;">Prescription writing and abbreviations</li><li fr-original-style="" style="box-sizing: border-box;">Classification of drugs</li><li fr-original-style="" style="box-sizing: border-box;">Common Abbreviations</li><li fr-original-style="" style="box-sizing: border-box;">Instruments and investigations</li><li fr-original-style="" style="box-sizing: border-box;">Medical Specialities and personnel</li><li fr-original-style="" style="box-sizing: border-box;">Blood tests</li></ul>At the end of the course students will have a clear understanding of medical terminology and are encouraged to use their newly learned skills in a series of quizzes and interactive games. All attendees are given a Certificate of Attendance and a comprehensive handout. Many people who attend these courses are keen to develop their skills further and may wish to proceed to the Level Two Intermediate Award in Medical Terminology. <iframe width="560" height="315" src="https://www.youtube.com/embed/tpzbsQuaZAY" title="YouTube video player" frameborder="0" allowfullscreen="" fr-original-style="" style="box-sizing: border-box;">&nbsp;&nbsp;</iframe> <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;"><h1 style="color: rgb(103, 106, 108); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(103, 106, 108);">Medical Terminology Training Courses</h1>Established in 2006 and the UK&rsquo;s largest provider of medical terminology training, we offer a range of courses to suit your needs from beginner through to advanced level. &nbsp;Our bespoke courses have been designed to suit the needs of healthcare professionals incorporating relevant terminology and content to directly benefit the workplace.Click &#39;more course information&#39; below to view further details of each of our courses.&nbsp;

An Introduction to Medical Terminology short course delivered online via Teams, suitable for anyone wishing to learn the basics of terminology. Dates of courses can be seen when clicking ‘register’ below.





Level One – Introduction to Medical Terminology.
“It's like a light has just been switched on and I now understand more of what I'm doing!” – Feedback from attendee of Level one course.
This course is aimed at anyone who requires a knowledge of medical terminology in their role. It is suitable for administrative staff, health care workers, medical secretaries, managers, Allied Health Professionals, essentially anyone who may encounter medical terminology and wishes to develop their medical terminology knowledge further. We also offer sessions to those requiring an overview of medical terminology to support applications to study medicine, veterinary medicine or dentistry.We can train between 1-30 learners from any organisation. If you have a specific training request, please speak to us and we can accommodate your needs. We recently trained a group of sign language interpreters who found the training invaluable when working in medical environments.The sessions are delivered via Teams (2x 2 hour meetings) so are highly accessible, a webcam and microphone are required although not essential.The aim of the course is for learners to develop an understanding of medical terminology in an enjoyable, interactive and informative way so that they are better able to decipher and unravel the mystery of long medical words.The course covers the following topics:-


Basics of medical terminology – word building
Common Roots, prefixes and suffixes
Anatomy and physiology via a virtual tour of the body
Major bones of the body
Prescription writing and abbreviations
Classification of drugs
Common Abbreviations
Instruments and investigations
Medical Specialities and personnel
Blood tests
At the end of the course students will have a clear understanding of medical terminology and are encouraged to use their newly learned skills in a series of quizzes and interactive games.

All attendees are given a Certificate of Attendance and a comprehensive handout.

Many people who attend these courses are keen to develop their skills further and may wish to proceed to the Level Two Intermediate Award in Medical Terminology.







Medical Terminology Training Courses

Established in 2006 and the UK’s largest provider of medical terminology training, we offer a range of courses to suit your needs from beginner through to advanced level. Our bespoke courses have been designed to suit the needs of healthcare professionals incorporating relevant terminology and content to directly benefit the workplace.
Click 'more course information' below to view further details of each of our courses. 

Mediterm Training

Medical Terminology

Medical Terminology Training Courses - Level 1

Reading

Nottingham

Dickson Training Ltd

ILM Level 3 Award in Leadership and Management

Online Course

Classroom Course

Nicola Slee is a theologian, writer and spiritual director. Author of numerous books exploring feminist theology, liturgy and spirituality, and much more. Her academic posts are: Professorial Research Fellow at the Queen&#39;s Foundation, Professor of Feminist Practical Theology at the Vrije Universiteit Amsterdam &amp; Visiting Professor at the University of Chester.

Nicola will help us to explore how our language and imagery for God plays out in prayer and spirituality, taking into account feminist and other critiques of dominant patriarchal and hierarchical God language and imagery. The evening will include input from Nicola, use of prayer and poetry, conversation in small groups and interaction with the speaker. 

Nicola Slee is a theologian, writer, poet and spiritual director. 
Nicola has wide-ranging experience of adult education and has a particular interest in feminist theology, practical theology and the role of poetry and the arts in Christian education and life. She has written numerous books and articles, exploring feminist theology, liturgy, spirituality, and much more.
She is Professorial Research Fellow at the Queen's Foundation for Ecumenical Theological Education, Birmingham; Professor of Feminist Practical Theology (the Queen’s chair) at The Vrije Universiteit Amsterdam, and Visiting Professor at the University of Chester.

The main input will be recorded and made available on request.
A reading list will be made available after the event. 

Spiritual Direction Forum UK

‘Gender, prayer, language and imagery for God’  with Professor Nicola Slee

These short-courses are designed to provide a snapshot into the key areas of the language for a variety of levels. &nbsp;Designed to be self-contained; you will not be required to purchase textbooks or extra materials; everything you need will be provided, including access to my online learning materials. &nbsp;You will also receive the PowerPoint slides, the agenda for the following week &amp; any homework set after each class. &nbsp;I have designed all the slides myself for thee 10-week courses, as I wanted to use my 10+ years of experience to develop something different from the traditional &ldquo;here&rsquo;s a textbook&rdquo; approach that lots of evening classes use. &nbsp;This class is designed to get you speaking in a way that will propel you forward with your language skills in practical settings.&nbsp;Each learner is entitled to a free 15-minute introduction session on Zoom so that we can get to know each other and assess your current level. &nbsp;I will also talk you through the controls on Zoom if you are not familiar with how to use it. &nbsp;Each course is comprised of 10 x 1 hour sessions. &nbsp;The groups will contain approximately 3-4 students (with an absolute maximum of 6 students) and are designed to encourage learners to strengthen their speaking skills in a relaxed, friendly atmosphere &amp; learn language skills in a social environment. &nbsp;If you miss a session, it may be possible to join another class running the same session at another time that week, or you can request receiving the learning materials via email. &nbsp;The courses are designed to have practical application for travel &amp; learning for personal interest. &nbsp;I firmly believe having a grammar component is key for long-term success with learning a language, but I promise to break it down so that it isn&rsquo;t overwhelming!When a 10-week course finishes, it will be followed by three weeks of optional revision classes. &nbsp;After this, you can simply choose to join the next level course, until you reach a level where you can join our conversation classes.You may also like to consider a blended learning approach; group classes are friendlier for your budget than private one-to-one tuition, but top up any time with one of my <a href="http://www.pronouncelanguages.co.uk/online-lessons" target="" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">private lessons</a> to consolidate your learning, ask further questions, revisiting themes or investigate a topic of particular interest to you that may not be covered in the short course. This second course from Pronounce Languages is designed for those who have already taken our Absolute Beginners course, or those who already have some existing knowledge of Spanish. &nbsp;It is strongly recommended that you discuss your level with your tutor before taking this course if you have not completed a class with us before.

Pronounce Languages

Spanish

Language Teaching

Teaching Online

Online Education

An exciting 10-week course to build your Spanish skills from scratch.  Practical applications for travel & conversation.  Enlarge your vocabulary, improve your grammar in a pain-free, step-by-step way, working with a tutor with 10+ years' experience & a small group of learners.

10-week Spanish course for Beginners (level 2)

Southend on Sea

Rotherham

Manchester

Slough

Portsmouth

Bingley

Paisley

Birmingham

Luton

Northampton

Bedford

Liverpool 

Swansea

BASIC to ADVANCED COURSE PACKAGE

Complete 3 courses over 2 full days and receive three qualifications:

Introduction to Phlebotomy Certificate (Nationally Recognised Level 3, Ireland Level 5)
Days 1 and 2: 9.30am – 5.00pm

Advanced Phlebotomy Certificate (Nationally Recognised Level 4, Ireland Level 6)
Day 1: 5.30pm - 8.30pm

Geopace Certificate of Competency (Nationally Recognised Accredited, CPD Practical Skills)
Day 2: 5.30pm - 8.30pm

Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.






Key Facts & Summary:


COURSE 1: INTRODUCTION TO PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Three (Ireland Level Five)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (21 CPD Points)

PART 1 (DAY 1) - 9.30am to 5.00pm
PART 2 (DAY 2) - 9.30am to 5.00pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

A TWO DAY venepuncture course at Level 3. Trains up to the point of live blood draws.

On completion awards a Nationally Recognised and Accredited Certificate in Phlebotomy.

DAY ONE (PART 1) - THEORY
Attend the course location of your choice – starts at 9.30am and finishes approx. 5.00pm

DAY TWO (PART 2) - CLASSROOM
Your classroom tutor will recap on the theory element (above) after which you will begin your practical sessions learning and developing the skills required up to the point of Live Blood Draws.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 2: ADVANCED PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Four (Ireland Level 6)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (14 CPD Points)

PART 1 - THEORY
Complete your theory training online in the comfort of your own home or at work.

PART 2 - CLASSROOM
Follow on from your Day One Theory training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

Skills and Practical Development:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.

On completion awards a Nationally Recognised and Accredited Certificate in Advanced Phlebotomy.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 3: ROUTE TO COMPETENCY MASTERCLASS
CPD ACCREDITED - The CPD Certification Service

CLASSROOM
Follow on from your Day Two practical training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

GEOPACE LIVE BLOOD SESSIONS enabling you to draw human blood under 1-to-1 supervision of your tutor. You will follow a Competency Checklist, signed off by your tutor on completion.

On completion awards a Geopace Certificate of Competency - Nationally Recognised and Accredited Route to Competency - Live Blood Draws Certificate

DOWNLOAD A COURSE ITINERARY HERE




How do I attend?

EITHER -
CLASSROOM OPTION - Attend one of our scheduled classroom locations, completing your Introduction to Phlebotomy Course over 2 days. You will also complete your Advanced Training at the end of the first day and your Competency Training at the end of the second day.

Our Introduction to Phlebotomy and Advanced Phlebotomy Training Kits are supplied at no charge when booking our virtual classroom training option.
If you would like to add one or both of these kits to your classroom training option then these are available to add at time of booking. Our comprehensive training kits each mirror the same equipment and supplies used in the classroom and both include detailed video tutorials, allowing you to continue to practice and "hone" your skills after you have completed your practical training.

OR -

VIRTUAL CLASSROOM OPTION- Complete your theory training online at home or work, then join us for a one day Zoom session to complete your Introduction to Phlebotomy virtual classroom training, followed by your Advanced Training in the evening of the same day. You have the option to add a classroom-based competency session, awarding a CPD Accredited Geopace Certificate of Competency, at time of booking.

Our Virtual Classroom option includes two very comprehensive training kits - one for your introductory course and one for your advanced course. Kits are included at no charge (normally £79.95 each) and are yours to keep and to continue to practice with after you have finished your courses. The equipment and supplies included in your kits are the same as those used if you choose the classroom option.

How do I book?

Choose whether you would like to attend in a classroom or if you would like to complete your training by virtual classroom.
Click on the Classroom - Booking Options or Virtual Classroom - Booking Options buttons below to see all upcoming dates and locations.

Please note - Competency Training
Our Route to Competency Masterclass - Live Blood Sessions can only be completed in a classroom environment. This is included when you book a classroom option. When booking the virtual classroom option you can choose to add this at time of booking. You will receive a voucher code to enable you to book onto any upcoming dates or locations. For most of our two day course we run our competency training at the end of the second day and therefore you should be able to complete your full training programme with us over two days.

If you are completing your training by virtual classroom please see our list of competency training locations here.

If you would like to "mix and match" your training dates and/or locations then please call our admin team on 01525 713377 who will be more than happy to put a training package together for you on dates and / or locations that suit you.

All courses are accredited and are Skills for Health & WHO compliant.

Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

THIS COURSE PACKAGE INCLUDES:
1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5)
2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6)
3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom)

Learn how to take blood ... train as a Phlebotomist

FAST-TRACK YOUR PHLEBOTOMY TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% off -  Multi-Course Discount

    Cover all stages from beginner through to Level 4

    Available as Classroom or Virtual Classroom

    Complete your beginner to advanced training in 2 days

    Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications

    Both courses are dually accredited (OCN & CPD)

    Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom

    Covers all steps up to live blood draw

    Learn advanced skills and techniques

    Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep)

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Phlebotomy Training - Beginner to Advanced PACKAGE

In this course, you&rsquo;ll gain a basic understanding of finance and accounting concepts to drive the success of your business.This course aims to demystify the accounting language over three hours so that you are in control of the financial performance of your business, helping you forecast for the future, evaluate your current efforts, and establish strategies to meet your goals.Date: Wednesday 25th September 2024Time: 9:30am - 12:30pmLocation: OnlineFor: Businesses based in North Essex (Braintree, Chelmsford, Colchester, Maldon, and Tendring)Cost: FreeMore about the courseEven if you plan to hire an accountant, you still need to understand accounting information to make better, more informed decisions about your business. This webinar will give you the tools necessary to have a better understanding of what the professionals are saying down the line, so you can run your business better.What it covers:Part 1<ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Historical business finance measurement</li><li fr-original-style="" style="box-sizing: border-box;">The main performance measure - Profit &amp; Loss</li><li fr-original-style="" style="box-sizing: border-box;">The main valuation measure - Balance Sheet</li><li fr-original-style="" style="box-sizing: border-box;"> The importance of cash management and working capital</li></ul>Part 2<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">How to apply this knowledge to business planning and targeting</li><li fr-original-style="" style="box-sizing: border-box;">Using the above measurement tools to help plan and forecast business performance, particularly Profit &amp; Loss and Cashflow and the key differences between them</li><li fr-original-style="" style="box-sizing: border-box;">Break even</li><li fr-original-style="" style="box-sizing: border-box;">Pricing methods</li></ul>Who it is for:The course is aimed at a whole range of businesses from start-up founders to local business owners to corporates, and is geared to anyone without a finance or accounting background. Your business must be based in or shortly relocating to North Essex (either Braintree, Chelmsford, Colchester, Maldon, or Tendring).Who should attend:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Entrepreneurs</li><li fr-original-style="" style="box-sizing: border-box;">Micro business owners</li><li fr-original-style="" style="box-sizing: border-box;">Small business owners</li><li fr-original-style="" style="box-sizing: border-box;">Middle managers</li><li fr-original-style="" style="box-sizing: border-box;">Consultants</li><li fr-original-style="" style="box-sizing: border-box;">Coaches</li><li fr-original-style="" style="box-sizing: border-box;">E-commerce businesses</li><li fr-original-style="" style="box-sizing: border-box;">Digital marketers</li><li fr-original-style="" style="box-sizing: border-box;">Service based business owners</li></ul>Skills gained:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand basic financial documents used in business</li><li fr-original-style="" style="box-sizing: border-box;">Interpret the information in these documents, and use it to manage day-to-day business activity</li><li fr-original-style="" style="box-sizing: border-box;">Be more effective in their role</li></ul>About the host:Jim Fletcher ACMA GCMAJim is a business manager with Let&#39;s Do Business Group and a dedicated business coach with 40 years&rsquo; commercial leadership experience. Drawing on his long career in the manufacturing and engineering sector, Jim provides tailored coaching, consultancy, non-executive directorship and project management services, across a full range of management, finance, sales &amp; marketing and operations functions.<hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;">This programme is delivered by the North Essex Economic Board (NEEB) in partnership with Let&#39;s Do Business Group.Let&#39;s Do Business Group is undertaking this project jointly with the&nbsp;<a href="https://neeb.org.uk/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://neeb.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">North Essex Economic Board (NEEB)</a>. The Board is a partnership of local authorities in the area: Braintree, Maldon, and Tendring district councils, Colchester Borough Council, Chelmsford City Council and Essex County Council.This project is funded by the UK Government through the UK Shared Prosperity Fund.The UK Shared Prosperity Fund is a central pillar of the UK government&#39;s Levelling Up agenda and provides &pound;2.6 billion of funding for local investment by March 2025. The Fund aims to improve pride in place and increase life chances across the UK investing in communities and place, supporting local business, and people and skills. For more information, visit&nbsp;<a href="https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus</a>Please click here to see our&nbsp;<a href="https://backingessexbusiness.co.uk/privacy-policy" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://backingessexbusiness.co.uk/privacy-policy" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Privacy Policy</a>. Please note that your details may be shared with the North Essex Economic Board who are funding this project.

In this course, you’ll gain a basic understanding of finance and accounting concepts to drive the success of your business.
This course aims to demystify the accounting language over three hours so that you are in control of the financial performance of your business, helping you forecast for the future, evaluate your current efforts, and establish strategies to meet your goals.
Date: Wednesday 25th September 2024
Time: 9:30am - 12:30pm
Location: Online
For: Businesses based in North Essex (Braintree, Chelmsford, Colchester, Maldon, and Tendring)
Cost: Free
More about the course
Even if you plan to hire an accountant, you still need to understand accounting information to make better, more informed decisions about your business. This webinar will give you the tools necessary to have a better understanding of what the professionals are saying down the line, so you can run your business better.
What it covers:
Part 1
Historical business finance measurement
The main performance measure - Profit & Loss
The main valuation measure - Balance Sheet
The importance of cash management and working capital
Part 2
How to apply this knowledge to business planning and targeting
Using the above measurement tools to help plan and forecast business performance, particularly Profit & Loss and Cashflow and the key differences between them
Break even
Pricing methods
Who it is for:
The course is aimed at a whole range of businesses from start-up founders to local business owners to corporates, and is geared to anyone without a finance or accounting background. Your business must be based in or shortly relocating to North Essex (either Braintree, Chelmsford, Colchester, Maldon, or Tendring).
Who should attend:
Entrepreneurs
Micro business owners
Small business owners
Middle managers
Consultants
Coaches
E-commerce businesses
Digital marketers
Service based business owners
Skills gained:
Understand basic financial documents used in business
Interpret the information in these documents, and use it to manage day-to-day business activity
Be more effective in their role
About the host:
Jim Fletcher ACMA GCMA
Jim is a business manager with Let's Do Business Group and a dedicated business coach with 40 years’ commercial leadership experience. Drawing on his long career in the manufacturing and engineering sector, Jim provides tailored coaching, consultancy, non-executive directorship and project management services, across a full range of management, finance, sales & marketing and operations functions.



This programme is delivered by the North Essex Economic Board (NEEB) in partnership with Let's Do Business Group.
Let's Do Business Group is undertaking this project jointly with the North Essex Economic Board (NEEB). The Board is a partnership of local authorities in the area: Braintree, Maldon, and Tendring district councils, Colchester Borough Council, Chelmsford City Council and Essex County Council.
This project is funded by the UK Government through the UK Shared Prosperity Fund.
The UK Shared Prosperity Fund is a central pillar of the UK government's Levelling Up agenda and provides £2.6 billion of funding for local investment by March 2025. The Fund aims to improve pride in place and increase life chances across the UK investing in communities and place, supporting local business, and people and skills. For more information, visit https://www.gov.uk/government/publications/uk-shared-prosperity-fund-prospectus
Please click here to see our Privacy Policy. Please note that your details may be shared with the North Essex Economic Board who are funding this project.

Let’s Do Business Group

This course aims to demystify the accounting language so that you are in control of the financial performance of your business, helping you forecast for the future, evaluate your current efforts, and establish strategies to meet your goals.

Finance for Non-Financial Entrepreneurs - North Essex

10122 Courses delivered Online

Mental Capacity Training

By The Teachers Training

TA Level 3: Teaching Assistant

By The Teachers Training

Property Developer and Estate Agent Diploma

By John Academy

Diet and Nutrition Practitioner Diploma

By John Academy

Complete Workplace Administration

By John Academy

Organic chemistry demystified : 12H course + solved problems

By John Academy

Aromatherapy Advanced Diploma

By John Academy

Advanced Excel Models using Formulas, VBA & Power Query

By John Academy

Django REST Framework - Full Stack Python APIs using Python

By John Academy

Career Developing Skills

By John Academy