Name: Electrical Engineering With Electric Circuits
Price: 10.99 GBP
Availability: InStock

<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes:<ul><li>Establish a strong foundation in SQL and MySQL.</li><li>Set up and configure SQL Server for efficient data handling.</li><li>Master SQL's Data Manipulation, Definition, and Control Language.</li><li>Create and optimize SQL queries for data analysis.</li><li>Perform advanced data analytics using SQL.</li><li>Understand the power of GROUP BY and JOIN statements.</li><li>Implement data constraints and views for data integrity and security.</li><li>Develop proficiency in stored procedures, data import/export, and database backup/restore.</li></ul> Why buy this Learn MySQL from Scratch for Data Science and Analytics? <ul><li>Unlimited access to the course for forever</li><li>Digital Certificate, Transcript, student ID all included in the price</li><li>Absolutely no hidden fees</li><li>Directly receive CPD accredited qualifications after course completion</li><li>Receive one to one assistance on every weekday from professionals</li><li>Immediately receive the PDF certificate after passing</li><li>Receive the original copies of your certificate and transcript on the next working day</li><li>Easily learn the skills and knowledge from the comfort of your home</li></ul> CertificationAfter studying the course materials of the Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for?This Learn MySQL from Scratch for Data Science and Analytics course is ideal for<ul><li>Aspiring Data Scientists and Analysts.</li><li>Database Administrators and Developers.</li><li>Students and professionals seeking to enter the field of Data Science.</li><li>Anyone looking to enhance their SQL and MySQL skills for data-related roles.</li></ul> PrerequisitesThis Learn MySQL from Scratch for Data Science and Analytics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path<ul><li>Data Analyst: £25,000 - £50,000 per year.</li><li>Database Administrator: £30,000 - £60,000 per year.</li><li>SQL Developer: £30,000 - £60,000 per year.</li><li>Data Scientist: £40,000 - £80,000 per year.</li><li>Business Intelligence Analyst: £35,000 - £65,000 per year.</li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><div>
				<h3>
	Course Curriculum
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Learn MySQL from Scratch for Data Science and Analytics</td>
				</tr>
								<tr>
					<td colspan="4">Section 01: Getting Started</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to get course requirements</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Getting started on Windows, Linux or Mac</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to ask great questions</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FAQ's</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What is Source Code?</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 02: SQL Server setting up</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>MySQL Server Installation</td>
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Connect MySQL Server Instance</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>MySQL Workbench overview</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Download and Restore Sample Database</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 03: SQL Database basics</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Overview of Databases</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Database</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SQL Data Types</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Column Data Types on Workbench</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Table</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Overview of Primary and Foreign Key</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Primary Key</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Foreign Key</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Temporary tables</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>EER - Enhanced Entity Relationship Diagrams</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 04: SQL DML (Data Manipulation Language)</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert statement</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Update statement</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Delete statement</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 05: SQL DDL (Data Definition Language)</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>CREATE table statement</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>DROP statement</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>ALTER statement</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>TRUNCATE statement</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>COMMENT in query</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>RENAME table</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 06: SQL DCL (Data Control Language)</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Database user</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>GRANT permissions</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>REVOKE permissions</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 07: SQL Statement Basic</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SQL Statement basic</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT Statement</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT DISTINCT</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT with column headings</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Column AS statement</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>DASHBOARD Analytics</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 08: Filtering Data rows</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT WHERE Clause - theory</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT WHERE Clause - practical</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 09: Aggregate functions for Data Analysis</td>
				</tr>
								<tr>
					<td></td>
					<td>Sum()</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Min()-Max()</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 10: SQL Data Analyticstatements</td>
				</tr>
								<tr>
					<td></td>
					<td>Order By statement</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT TOP 3 records</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>BETWEEN command</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IN operator</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Search Data usingLIKE cards</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 11: SQL Group by statement</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Group by - theory</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Analytics with Group By</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>HAVING statement</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 12: JOINS</td>
				</tr>
								<tr>
					<td></td>
					<td>Overview of Joins</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What are Joins</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Inner join</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Left outer join</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Right outer join</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Union</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>CERTESIAN Product or Cross Join</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Query Exercise</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Solution for Query Exercise</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 13: SQL Constraints</td>
				</tr>
								<tr>
					<td></td>
					<td>Section introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Check constraint</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>NOT NULL constraint</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>UNIQUE constraint</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 14: Views</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Views</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Analytic Views from multiple tables</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 15: Advanced SQL Functions</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Timestamp</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Extract from timestamp</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Mathematical scalar functions</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>String functions3</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advanced functions</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sub Queries</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT with calculations</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 16: SQL Stored procedures</td>
				</tr>
								<tr>
					<td></td>
					<td>Create stored procedure</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Stored procedure with parameter</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Drop Procedure</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 17: Import &amp; Export data</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Import .csv file</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Export Data to .csv file</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 18: Backup and Restore Database</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Database backup</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Restoring Database backup</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

Learning & Development

Data Engineering

Microsoft SQL

AWS Certified Database

Data Skills

Trainers Course

Learn MySQL from Scratch for Data Science and Analytics

General Admission

Guarantee a successful career in real estate with the Real Estate Agent course training programme!
Through this course, you will learn how the real estate industry works and will gain the most up-to-date skills to start building your property portfolio. Not only that, but you will gain the interpersonal skills and business skills needed to launch your career successfully and stand out from the competition.
Gain an industry-recognised qualification to fast track your career and learn best practises from this best-selling bundle training program. This course is the perfect stepping stone to a successful career as an Estate Agent.
Learning Outcomes
<ul>
<li>Navigate the roles and responsibilities of estate agents across various sectors.</li>
<li>Cultivate a robust method for listing and valuing properties effectively.</li>
<li>Enhance negotiation techniques to become a formidable advocate for clients.</li>
<li>Implement strategic time management and productivity amplifying methods.</li>
<li>Invest in property with acumen and build a diverse, profitable portfolio.</li>
</ul>
<h3>Why choose this Real Estate Agent course?</h3>
<ol>
<li>Unlimited access to the course for a lifetime.</li>
<li>Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course.</li>
<li>Structured lesson planning in line with industry standards.</li>
<li>Immerse yourself in innovative and captivating course materials and activities.</li>
<li>Assessments designed to evaluate advanced cognitive abilities and skill proficiency.</li>
<li>Flexibility to complete the Course at your own pace, on your own schedule.</li>
<li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.</li>
<li>Unlock career resources for CV improvement, interview readiness, and job success.</li>
</ol>
<h3>Who is this Real Estate Agent course for?</h3>
<ul>
<li>Novices with aspirations to penetrate the real estate industry.</li>
<li>Seasoned professionals aiming to refresh and expand their expertise.</li>
<li>Investors looking to enrich their knowledge of real estate transactions.</li>
<li>Individuals pursuing skills in property portfolio expansion.</li>
<li>Professionals desiring to elevate their persuasive communication abilities.</li>
</ul>
<h3>Career path</h3>
<ul>
<li>Estate Agent: £18,000 - £30,000</li>
<li>Property Manager: £20,000 - £35,000</li>
<li>Real Estate Investment Analyst: £25,000 - £55,000</li>
<li>Portfolio Manager: £40,000 - £70,000</li>
<li>Lettings Negotiator: £15,000 - £25,000</li>
<li>Real Estate Developer: £30,000 - £70,000+</li>
</ul>
<h3>Prerequisites</h3>
This Real Estate Agent does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Real Estate Agent was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
<h3>Certification</h3>
After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.<div>
				<h3>
	Course Curriculum
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">***Estate Agent Diploma***</td>
				</tr>
								<tr>
					<td colspan="4">Introduction to the Course</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to the Course - Estate Agent</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 01 - Estate Agent: An Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>Estate Agent: An Introduction</td>
					<td> </td>
					<td> 00:24:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 02 - Different Types of Estate Agents</td>
				</tr>
								<tr>
					<td></td>
					<td>Different Types of Estate Agents</td>
					<td> </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 03 - Getting Started on the Job</td>
				</tr>
								<tr>
					<td></td>
					<td>Getting Started on the Job</td>
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 04 - Listing Property: Finding the Sellers</td>
				</tr>
								<tr>
					<td></td>
					<td>Listing Property: Finding the Sellers</td>
					<td> </td>
					<td> 00:27:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 05 - Valuation Process</td>
				</tr>
								<tr>
					<td></td>
					<td>Valuation Process</td>
					<td> </td>
					<td> 00:24:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 06 - Negotiating as Estate Agent</td>
				</tr>
								<tr>
					<td></td>
					<td>Negotiating as Estate Agent</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 07 - Selling Property: Finding the Buyers</td>
				</tr>
								<tr>
					<td></td>
					<td>Selling Property: Finding the Buyers</td>
					<td> </td>
					<td> 00:26:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 08 - Letting Property</td>
				</tr>
								<tr>
					<td></td>
					<td>Letting Property</td>
					<td> </td>
					<td> 00:34:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 09 - Technology for Estate Agents</td>
				</tr>
								<tr>
					<td></td>
					<td>Technology for Estate Agents</td>
					<td> </td>
					<td> 00:24:00</td>
				</tr>
								<tr>
					<td colspan="4">Module 10 - Regulation of Estate Agents</td>
				</tr>
								<tr>
					<td></td>
					<td>Regulation of Estate Agents</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td colspan="4">Final Recap</td>
				</tr>
								<tr>
					<td></td>
					<td>Final Recap to the Course</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
								<tr>
					<td colspan="4">***Time Management &amp; Productivity Training in Real Estate***</td>
				</tr>
								<tr>
					<td colspan="4">Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>Meet Your Instructor</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Why Shawn as Your Instructor? - Personal Success Story</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Roadmap to Do More Deals in Less Time</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Time Management Trough Tempo Methodology</td>
				</tr>
								<tr>
					<td></td>
					<td>What is Tempo Methodology?</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The First Step to BOOSTING Productivity</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Personal Strategy Assessment Time!</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to Make the Necessary Changes</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Developing a SUCCESSFUL Game-plan</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>It's Go Time..</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Tempo Methodology Machine</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Productivity Killers - How to MINIMIZE</td>
				</tr>
								<tr>
					<td></td>
					<td>Avoiding Your Email Inbox Nightmare</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SILENT but DEADLY Productivity Killers</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What are Electives? How Do We Stop Them</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Mind Blowing Social Media Trends</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Productivity Boosters - How to MAXIMIZE</td>
				</tr>
								<tr>
					<td></td>
					<td>Step 1 is Always NUKE IT</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Mastering the Art of Goal Setting</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Prioritize - Prioritize - PRIORITIZE</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Mini Strategies for Success!</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Return on Time Invested (ROTI)</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Exponentially AMPLIFY Your Time</td>
				</tr>
								<tr>
					<td></td>
					<td>How to Manage 1,000 Clients w/ 1 Click</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Simple Tip for Staying Focused</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to Wake Up Every Day Ready to Succeed</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Simple Technique to Sleep FASTER &amp; Feel BETTER</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to Increase Efficiency by 300%</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td></td>
					<td>My Thanks to You</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Bonus</td>
				</tr>
								<tr>
					<td></td>
					<td>What's Next? (BONUS)</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">***Real Estate Investment Training***</td>
				</tr>
								<tr>
					<td colspan="4">Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction Super Real Estate Investing</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Why Real Estate Continues to Be the Best Investment for Most People</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td colspan="4">Getting Amazing Deals on Properties</td>
				</tr>
								<tr>
					<td></td>
					<td>How to buy houses for super cheap</td>
					<td> </td>
					<td> 00:21:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to use direct marketing to reach motivated sellers</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td colspan="4">How to Finance Real Estate Deals</td>
				</tr>
								<tr>
					<td></td>
					<td>Secrets to financing all kinds of deals</td>
					<td> </td>
					<td> 00:17:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Understanding Hard Money</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>More Hard Money Examples</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td colspan="4">How to Execute Effective Exit Strategies</td>
				</tr>
								<tr>
					<td></td>
					<td>The best exit strategies in real estate</td>
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Secrets to wholesaling properties to other investors</td>
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Secrets to rehabbing the property and maximizing profit</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Making Money with Tax Lien Certificates and Deeds</td>
				</tr>
								<tr>
					<td></td>
					<td>Secrets to buying tax lien certificates and tax deeds</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td colspan="4">Building Wealth and Passive Income Through Rental Properties</td>
				</tr>
								<tr>
					<td></td>
					<td>Buying and renting for maximum passive income</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>REI Secrets, Tips, and Tricks</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>More REI Secrets, Tips, and Tricks</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Even more REI Secrets, Tips, and Tricks</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td></td>
					<td>Conclusion Super Real Estate</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">***Portfolio Building for Property***</td>
				</tr>
								<tr>
					<td colspan="4">Module: 01</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The answer is Property</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Mortgage Types</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Negative Mind Chatter</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 02</td>
				</tr>
								<tr>
					<td></td>
					<td>Steps in the Plan</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Property Types</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Set it up and Forget about it</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Raising the Capital</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Watch Your Cashflow</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Look at the costs</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td colspan="4">Module: 03</td>
				</tr>
								<tr>
					<td></td>
					<td>Portfolio building strategy</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Historic Property Cycles</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Make your portfolio grow faster</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Ways to Create Income</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Understanding Inflation</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">***Persuasion and Influencing Skills***</td>
				</tr>
								<tr>
					<td></td>
					<td>What Is Influence &amp; Why is It Important!</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Power To influence - Beginning Concepts</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The 6 Master Principles Of Persuasion - Part 1</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The 6 Master Principles Of Persuasion - Part 2</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The MUST Have Persuasion Tool!</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Emotional Reasoning</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>MORE Powerful Tools Of Persuasion</td>
					<td> </td>
					<td> 00:17:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Rapport Building &amp; Reputation - Part 1</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Rapport Building &amp; Reputation - Part 2</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Powerful Tools Of Persuasion - Part 1</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Powerful Tools Of Persuasion - Part 2</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Powerful Tools Of Persuasion - Part 3</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Mock Exam - Real Estate Agent</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td></td>
					<td>Final Exam - Real Estate Agent</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
				</tbody></table></div>

			</div>

Online Course Marketing

Estate Agent

Letting Agent

Real Estate Investing

Education Agent

Real Estate Marketing

Real Estate Agent

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights.
Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas.
Learning Outcomes
<ul>
<li>Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query</li>
<li>Develop expertise in financial modeling using prepaid expenses models</li>
<li>Master the calculation of amortization schedules and prepaid expenses summaries</li>
<li>Implement Power Query to manipulate and analyze large datasets</li>
<li>Create dynamic dashboards without the limitations of formulas</li>
<li>Enhance your Excel skills and data analysis capabilities</li>
</ul>
<h3>Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course?</h3>
<ol>
<li>Unlimited access to the course for a lifetime.</li>
<li>Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course.</li>
<li>Structured lesson planning in line with industry standards.</li>
<li>Immerse yourself in innovative and captivating course materials and activities.</li>
<li>Assessments designed to evaluate advanced cognitive abilities and skill proficiency.</li>
<li>Flexibility to complete the Course at your own pace, on your own schedule.</li>
<li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.</li>
<li>Unlock career resources for CV improvement, interview readiness, and job success.</li>
</ol>
<h3>Who is this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for?</h3>
<ul>
<li>Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation</li>
<li>Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization</li>
<li>Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query</li>
<li>Individuals seeking to create interactive and insightful dashboards for data-driven decision-making</li>
<li>Anyone seeking to elevate their Excel skills and become a proficient data analyst</li>
</ul>
<h3>Career path</h3>
<ul>
<li>Financial Analyst (£35,000 - £55,000)</li>
<li>Business Analyst (£40,000 - £60,000)</li>
<li>Data Analyst (£45,000 - £65,000)</li>
<li>Management Accountant (£40,000 - £60,000)</li>
<li>Business Intelligence Analyst (£45,000 - £65,000)</li>
<li>Senior Financial Analyst (£50,000 - £70,000)</li>
</ul>
<h3>Prerequisites</h3>
This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
<h3>Certification</h3>
After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.<div>
				<h3>
	Course Curriculum
</h3>

<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">Thank you</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">Assignment</td>
				</tr>
								<tr>
					<td></td>
					<td>Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table></div>

			</div>

Financial Modelling & Analysis

Finance Cert & Exam Prep

Microsoft Power BI

Excel Analytics

Microsoft Excel

Practical Accounting

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

Online Course Creation

Cyber Security

Hacking

Certified Ethical Hacker (CEH)

Cyber Security Foundation

Ethical Hacking

Website Hacking From Scratch

Ethereum Blockchain DApp using Solidity

Clinical Coding

Certificate of Completion (CCL)

IT Certifications

Medical Coding

Institute of Leadership & Management (ILM)

ICDL (International Certification of Digital Literacy)

Certificate in Medical Coding- ICD-10-CM at QLS Level 3

NLP Practitioner

Learning To Learn

Deep Learning

Deep Learning & Neural Networks Python - Keras

HTML & CSS

Web Designer

Web Development

Web Design

HTML and CSS Coding: Beginner to Advanced

Microsoft Certification

CompTIA Network+

Computer Skills

CompTIA A+

CompTIA Security+

Diploma in CompTIA A+

Electrical

Electrical Engineering

Electrical Testing

Electrotechnical

Electrical Design

Electrical engineering (EE)

Electrical Engineering With Electric Circuits

Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education&rsquo;s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process. It also has an incredible average delegate rating of 4.97 out of 5 for overall quality, with 100% of former delegates recommending the course (please see our many fantastic testimonials&nbsp;<a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_self" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">here</a>).The highly acclaimed Senior Mental Health Lead Training and Certificate is an extensive and authoritative training course that ensures schools/colleges have the most comprehensive, effective and financially viable whole-school/college approach to mental health and wellbeing in place. Since September 2021, this course has been fully funded by the DfE for eligible schools&nbsp;and colleges. Schools and Colleges that are ineligible for the grant are, of course, more than welcome to enrol on the course but will need to self-fund their place.Working with an&nbsp;expert trainer and a highly experienced Senior Mental Health Lead, who has&nbsp;trained Senior Mental Health Leads in over 1000 schools and colleges nationwide, you will be introduced to the DfE&rsquo;s requirements for the role of the DSMHL, and learn proven, long-term, evidence-based strategies to create, lead and promote a dynamic, bespoke mental health and wellbeing approach for your setting.<ul style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><li fr-original-style="" style="box-sizing: border-box;">Our course consists of three days of live instructor-led training as well as an additional 1-2-1 review and coaching session, and costs&nbsp;&pound;520+VAT per delegate.&nbsp;(For schools and colleges who have already completed the training with us and now wish to train further colleagues, we offer a&nbsp;subsidised rate for additional delegates of &pound;390+VAT&nbsp;- please just email us if this is an offer you would like to take up.)</li><li fr-original-style="" style="box-sizing: border-box;">Places are limited to a maximum of 15 delegates per course to ensure high quality, bespoke training.</li><li fr-original-style="" style="box-sizing: border-box;">An overview of the course structure can be found&nbsp;<a href="https://www.brightcoreconsultancy.com/_files/ugd/5bc70a_c7b3efd99188442fa7d20449bb8fd0ec.pdf" target="_blank" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">here.</a></li></ul>Our Course is suitable for those who are new to the role of Senior Mental Health Lead or those who are looking to take on this role in the near future, and is designed to meet the DfE&rsquo;s&nbsp;<a href="https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/995681/Learning_outcomes_for_senior_mental_health_leads_in_schools_and_colleges.pdf" target="_blank" rel="noreferrer noopener" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">Learning Outcomes for Senior Mental Health Leads</a>&nbsp;by developing and supporting their knowledge and understanding of how to design, implement and sustain an effective whole school/college approach in accordance with the eight key principles as set out by Public Health England.<a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" 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;" fr-original-class="wysiwyg_bold_link_cls">View all testimonials </a>

Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education’s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process. It also has an incredible average delegate rating of 4.97 out of 5 for overall quality, with 100% of former delegates recommending the course (please see our many fantastic testimonials here).
The highly acclaimed Senior Mental Health Lead Training and Certificate is an extensive and authoritative training course that ensures schools/colleges have the most comprehensive, effective and financially viable whole-school/college approach to mental health and wellbeing in place. Since September 2021, this course has been fully funded by the DfE for eligible schools and colleges. Schools and Colleges that are ineligible for the grant are, of course, more than welcome to enrol on the course but will need to self-fund their place.
Working with an expert trainer and a highly experienced Senior Mental Health Lead, who has trained Senior Mental Health Leads in over 1000 schools and colleges nationwide, you will be introduced to the DfE’s requirements for the role of the DSMHL, and learn proven, long-term, evidence-based strategies to create, lead and promote a dynamic, bespoke mental health and wellbeing approach for your setting.
Our course consists of three days of live instructor-led training as well as an additional 1-2-1 review and coaching session, and costs £520+VAT per delegate. (For schools and colleges who have already completed the training with us and now wish to train further colleagues, we offer a subsidised rate for additional delegates of £390+VAT - please just email us if this is an offer you would like to take up.)
Places are limited to a maximum of 15 delegates per course to ensure high quality, bespoke training.
An overview of the course structure can be found here.
Our Course is suitable for those who are new to the role of Senior Mental Health Lead or those who are looking to take on this role in the near future, and is designed to meet the DfE’s Learning Outcomes for Senior Mental Health Leads by developing and supporting their knowledge and understanding of how to design, implement and sustain an effective whole school/college approach in accordance with the eight key principles as set out by Public Health England.
View all testimonials



Brightcore Consultancy

Mental Health

Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education’s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process.

Designated Senior Mental Health Lead Course (Three full days plus 1-2-1 session)

Belfast

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">The purpose of this&nbsp;qualification&nbsp;is to enable&nbsp;learners to develop the&nbsp;knowledge and skills&nbsp;so they can engage, facilitate, educate and support clients in a gym or health club environment.Completing this qualification allows learners to access Gym Instructor jobs.Qualification Structure:<li id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 1 &ndash; Anatomy &amp; physiology for exercise &amp; fitness instructors</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 2 &ndash; Providing a positive customer experience in the exercise environment</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 3 &ndash; Lifestyle management &amp; health awareness</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 4 &ndash; Gym-based programme planning and preparation</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 5 &ndash; Gym-based programme delivery and professional instruction</li><div fr-original-style="" style="box-sizing: border-box;"> </div><div fr-original-style="" style="box-sizing: border-box;">Entry Requirements:</div><div fr-original-style="" style="box-sizing: border-box;">Learners must be aged 16 plus. Ideally they should have some experience of gym-based exercises as participation in a variety of gym-based practical sessions will be required throughout the qualification. Learners should also have communication skills pitched at level 2 which can be developed during the course. </div><div fr-original-style="" style="box-sizing: border-box;"> </div><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Assessments:</div><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Multiple choice testAssessment workbookObservation of practical skillsPortfolio of evidence (Learner assessment record)</ul></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"> </div>

The purpose of this qualification is to enable learners to develop the knowledge and skills so they can engage, facilitate, educate and support clients in a gym or health club environment.
Completing this qualification allows learners to access Gym Instructor jobs.
Qualification Structure:
Unit 1 – Anatomy & physiology for exercise & fitness instructors
Unit 2 – Providing a positive customer experience in the exercise environment
Unit 3 – Lifestyle management & health awareness
Unit 4 – Gym-based programme planning and preparation
Unit 5 – Gym-based programme delivery and professional instruction
Entry Requirements:Learners must be aged 16 plus. Ideally they should have some experience of gym-based exercises as participation in a variety of gym-based practical sessions will be required throughout the qualification. Learners should also have communication skills pitched at level 2 which can be developed during the course.

Assessments:
Multiple choice test
Assessment workbook
Observation of practical skills
Portfolio of evidence (Learner assessment record)

Platinum Training Institute

Physical Activity

The purpose of this qualification is to enable learners to develop the knowledge and skills so they can engage, facilitate, educate and support clients in a gym or health club environment.

Completing this qualification allows learners to access Gym Instructor jobs.

YMCA Level 2 Certificate in Gym Instructing

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">The purpose&nbsp;of these qualifications is to enable learners to coach clients &ndash; one to one and in small groups &ndash; towards their health and fitness goals. Learners will develop the knowledge, skills and behaviours to plan and deliver creative and personalised exercise programmes, provide nutritional advice and support clients with their overall lifestyle management.This qualification is mapped directly to:The Chartered Institute for the Management of Sport and Physical Activity (CIMSPA) professional standards for a Personal Trainer.Qualification Structure:<ul style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Unit 1: Anatomy &amp; physiology for exercise &amp; fitness instructors</li><li fr-original-style="" style="box-sizing: border-box;">Unit 2: Providing a positive customer experience in the exercise environment</li><li fr-original-style="" style="box-sizing: border-box;">Unit 3: Lifestyle management &amp; health awareness</li><li fr-original-style="" style="box-sizing: border-box;">Unit 4: Gym-based programme planning and preparation</li><li fr-original-style="" style="box-sizing: border-box;">Unit 5: Gym-based programme delivery and professional instruction</li><li fr-original-style="" style="box-sizing: border-box;">Unit 6: Applied anatomy and physiology</li><li fr-original-style="" style="box-sizing: border-box;">Unit 7: Promoting wellness through client motivation and interaction</li><li fr-original-style="" style="box-sizing: border-box;">Unit 8: Bespoke exercise programme design</li><li fr-original-style="" style="box-sizing: border-box;">Unit 9: Customised exercise programme instruction and communication techniques</li><li fr-original-style="" style="box-sizing: border-box;">Unit 10: Nutrition to support physical activity</li><li fr-original-style="" style="box-sizing: border-box;">Unit 11: Business acumen for a successful Personal Training Practice</li></ul><div fr-original-style="" style="box-sizing: border-box;"> </div><div fr-original-style="" style="box-sizing: border-box;">Entry Requirements:</div>Learners must be aged 16 plus. Ideally they should have some experience of gym-based exercises as participation in a variety of gym-based practical sessions will be required throughout the qualification. Learners should also have communication skills pitched at level 2 which can be developed during the course.<div fr-original-style="" style="box-sizing: border-box;"> </div><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Assessments:</div><div style="color: rgb(105, 105, 105); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(105, 105, 105);"><section fr-original-style="" style="box-sizing: border-box;"><div data-tags="{All} " fr-original-style="" style="box-sizing: border-box;"><div itemprop="text" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Multiple choice testAssessment workbookObservation of practical skillsPortfolio of evidence (Learner assessment record) <div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Add Ons:</div>If you choose the Gold or Platinum Course you will receive the following:NASM Certified Nutrition Coach (CNC) - *Platinum OnlyNASM Behaviour Change Science: Help Clients Stick with their ProgrammeNASM Speed Agility and Quickness TrainingNASM Navigating DietsNASM Anatomy of a Research paper: How to Read beyond the Abstract</div> </div></section></div></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"> </div>

The purpose of these qualifications is to enable learners to coach clients – one to one and in small groups – towards their health and fitness goals. Learners will develop the knowledge, skills and behaviours to plan and deliver creative and personalised exercise programmes, provide nutritional advice and support clients with their overall lifestyle management.
This qualification is mapped directly to:
The Chartered Institute for the Management of Sport and Physical Activity (CIMSPA) professional standards for a Personal Trainer.
Qualification Structure:
Unit 1: Anatomy & physiology for exercise & fitness instructors
Unit 2: Providing a positive customer experience in the exercise environment
Unit 3: Lifestyle management & health awareness
Unit 4: Gym-based programme planning and preparation
Unit 5: Gym-based programme delivery and professional instruction
Unit 6: Applied anatomy and physiology
Unit 7: Promoting wellness through client motivation and interaction
Unit 8: Bespoke exercise programme design
Unit 9: Customised exercise programme instruction and communication techniques
Unit 10: Nutrition to support physical activity
Unit 11: Business acumen for a successful Personal Training Practice
Entry Requirements:
Learners must be aged 16 plus. Ideally they should have some experience of gym-based exercises as participation in a variety of gym-based practical sessions will be required throughout the qualification. Learners should also have communication skills pitched at level 2 which can be developed during the course.
Assessments:
Multiple choice test
Assessment workbook
Observation of practical skills
Portfolio of evidence (Learner assessment record)


Add Ons:
If you choose the Gold or Platinum Course you will receive the following:
NASM Certified Nutrition Coach (CNC) - *Platinum Only
NASM Behaviour Change Science: Help Clients Stick with their Programme
NASM Speed Agility and Quickness Training
NASM Navigating Diets
NASM Anatomy of a Research paper: How to Read beyond the Abstract

NASM

Personal Trainer

Coaching

Sport

Fitness

The purpose of these qualifications is to enable learners to coach clients – one to one and in small groups – towards their health and fitness goals. Learners will develop the knowledge, skills and behaviours to plan and deliver creative and personalised exercise programmes, provide nutritional advice and support clients with their overall lifestyle management.

PTI Diploma in Personal Training

The industry standard course in UX researchMaster the research skills that make UX professionals so valuable. Become a confident, credible and effective user researcher with a globally recognised qualification.<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;">Who is it for?UX professionals Aspiring UX researchersDuration16 weeksCommitment3 hours per weekFormatOnline, self-paced with live support and mentoring <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;">Why take this user research course:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Gain the most in-demand skills* and boost your career in a thriving industry.</li><li fr-original-style="" style="box-sizing: border-box;">Learn a complete range of UX research methods. Expand your toolkit to conduct high-quality research at pace.</li><li fr-original-style="" style="box-sizing: border-box;">Become an insights expert. Translate findings into actionable insights and communicate them with conviction.</li><li fr-original-style="" style="box-sizing: border-box;">Showcase your expertise. Build a professional user research portfolio and earn a university credit-rated qualification.</li><li fr-original-style="" style="box-sizing: border-box;">Get the confidence to succeed. Count on our mentors, career advisors and student community throughout your journey.</li></ul>*Research is one of the top 10 most in-demand skills globally (LinkedIn, 2023).<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;"><section style="color: rgb(15, 21, 26); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);"><section style="color: rgb(15, 21, 26); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);"><section style="color: rgb(15, 21, 26); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);">A comprehensive, in-depth curriculumThis user research course has been created and validated by experts in UX research. It is credit-rated by Glasgow Caledonian University.Self-paced learning gives you the flexibility to study in your own time. Monthly deadlines and submissions give you structure and accountability. The best of both worlds.</section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"> </section></section></section>Module 1Introduction to user researchUnderstand the role of a UX researcher. Explore the types, methods and ethics of research. Module 2Planning the researchLearn how to build a research plan, collaborate with stakeholders, recruit participants and manage data. Module 3Fundamental user research skillsMaster the core skills of interviewing and usability testing. Learn how to moderate and take notes. Module 4Expanding your toolkitExplore qualitative research methods like ethnography, contextual enquiry, service safaris and diary studies. Module 5Analysing qualitative researchLearn to analyse research data and translate it into user goals, affinity diagrams, personas and journey maps. Module 6Quantitative researchLearn to design, conduct and analyse online surveys, A/B tests and more. Module 7Communicating the researchLearn how to report and present your findings with confidence. Module 8AI for user researchExplore how AI tools can assist researchers. ProjectPortfolio projectBuild a professional portfolio to showcase your research expertise.

UX Design Institute 

User Research

Professional Certificate in User Research

Early Bird Price

This engaging and dynamic advanced CPD-certified course is an extension to the Born at the Right Time Essentials in Communication and Co-production with Parents/Carers. We recommend that you have completed the &#39;Essentials&#39; course before booking this course (please see our booking page or contact admin@bornattherighttime.com to find out more).&nbsp;Founded on lived experience, this course looks at the key factors which lead to a break down in relationships between parents/carers and practitioners, how this understanding can inform next steps and what meaningful connections between professionals and families might look like. Practitioners should come ready to be interactive and reflective as well as learning from psychology, sociology and research into trauma informed care. Content<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Using lived experience to understand what can lead to conflict and relationship breakdown&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;">Relationship building and avoiding conflict and the factors underpinning challenging situations and difficult conversations&nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">System structures which negatively affect effective communication and collaboration&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The impact of trauma and use of trauma informed practice&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">BRAVING inventory (Brene Brown) and creating healthy boundaries&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Ways to create professional, meaningful connection with parents/carers in the current context. </li></ul>Delivery<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">2 x 3.5 hours virtual live event (7 hour CPD) on 10th and 17th October 2024</li></ul>

This engaging and dynamic advanced CPD-certified course is an extension to the Born at the Right Time Essentials in Communication and Co-production with Parents/Carers. We recommend that you have completed the 'Essentials' course before booking this course (please see our booking page or contact admin@bornattherighttime.com to find out more). 
Founded on lived experience, this course looks at the key factors which lead to a break down in relationships between parents/carers and practitioners, how this understanding can inform next steps and what meaningful connections between professionals and families might look like. Practitioners should come ready to be interactive and reflective as well as learning from psychology, sociology and research into trauma informed care.

Content
Using lived experience to understand what can lead to conflict and relationship breakdown
Relationship building and avoiding conflict and the factors underpinning challenging situations and difficult conversations
System structures which negatively affect effective communication and collaboration
The impact of trauma and use of trauma informed practice
BRAVING inventory (Brene Brown) and creating healthy boundaries
Ways to create professional, meaningful connection with parents/carers in the current context.
Delivery
2 x 3.5 hours virtual live event (7 hour CPD) on 10th and 17th October 2024

Born at the Right Time

Learning Disability Nurse

Allied Health

SENCO

Allied Health Professions (AHP)

Midwifery

Healthcare Workers

Sen Teaching Assistant

Speech & Language Therapist

Social Worker

Occupational Therapist

Disability Awareness

Speech & Language Therapy (SLT)

Social Care

Learning Disability

Physiotherapist

Inspiring, interactive and unique 4-hour CPD certified Communication and Co-production training. 

Difficult Conversations, Conflict and Relationship Building with Parents/Carers (Oct 24)

<div id="course-pills-1">Duration2 Days12 CPD hoursThis course is intended forThis course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.</div>

Nexus Human

Design & Technology Courses (DT)

Microsoft AZ-303

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

Contents:
- Workshop Overview
- Topics
- Who should attend
- Group Rates
- Chynna Clayton Bio
- Kate Wood Bio
- Past Attendee Feedback




EA/PA Excellence Workshop
We are delighted to announce three dates for our exclusive EA/PA Excellence Workshop facilitated by Kate Wood and keynoted by Chynna Clayton "Body Woman" to Michelle Obama former First Lady of the United States of America. 
Our aims for this workshop:
Build and maintain resilience in the face of ever-increasing demands on time and energy
Add to best-practice strategies for strengthening relationships online with colleagues, clients and key stakeholders
Develop influencing skills to confidently handle difficult front-line situations and people
Topic 1
Handling pressure with resilience

Recognise what's within your control and how to let go of what's not
Learn the science behind negative thinking and how to retrain your brain for maximum impact
Explore how to find the bright spot in your ever-changing workstack for motivation
Topic 2
Strengthening working relationships online
Understand why online working makes it difficult to get people to do what you need
Discover how best to build trust and connection when working remotely and in hybrid environments
Learn the key do's and don'ts for virtual communication
Topic 3
Managing time and boundaries
Use conflict-handling strategies confidently for long-term benefits
Practice ways to hold your ground without damaging your reputation
Create and maintain boundaries for personal effectiveness
Keynote Address with Q&A from the audience:
Keynote from Chynna Clayton former assistant to First Lady of the United States, Michelle Obama.
Opportunity for the audience to take part in a Q&A with Chynna on how to excel within an administration role



Who will attend?
PA's
EA's
Administrative roles
This workshop is open to females, male including trans women/males and non-binary professionals.







Group Rate Discounts
Group discounts are on request - please call 0800 949 9111 or email support@ownyoursuccess.co.uk if you need support around this matter. 





Chynna Clayton Bio
Keynote Speaker
 

Empathetic, strategic, and meticulous about the details, Chynna Clayton has built a career enabling some of the world’s most influential leaders to excel in high-stress environments.
Chynna is the founder and CEO of Matriarch Made Development, a consulting firm that helps organizations develop high performing administrative teams and identify and address overall operating structure
and events logistics inefficiencies. From helping leaders figure out their onboarding, communication flow, event logistics and how to further develop the talents of their teams, Chynna supports leading organizations in creating a systematic approach to tackling business/events challenges and bottlenecks.
Prior to Matriarch Made, Chynna worked in the personal office of Barack and Michelle Obama as their Director of Travel and Event Operations. Her career also includes administrative roles at Disney and the White House where she served as “body woman” to Mrs. Obama during the Obama Administration.
Chynna graduated from University of Florida with a B.S. in Event Management and Political Science and a minor in Business. She currently resides in Washington, DC with her wife, Retired Naval Chief Petty Officer, Katina Hoyles.
Chynna was featured in Michelle Obama’s latest book, The Light We Carry

“She could adapt in all types of environments, remain­ing unflappable in the face of change. On any given day, I might go from having a conversation with a group of students at a school to filming a television show or recording a podcast. I could meet with a world leader or the head of a philanthropic organization and then have dinner with A-list celebrities. It was Chynna facilitating every move.”
— Direct Quote from Michelle Obama in The Light We Carry
Chynna Featured on The Michelle Obama's Podcast




Kate Wood
Workshop Facilitator 

 
Kate is a business owner, qualified coach, consultant, facilitator, trainer, podcaster and public speaker with a background in learning & development, employee engagement strategy, continuous improvement, communications and marketing. After 25 years working across the board in blue-chip, non-profit and civil service organisations she now provides support to businesses looking to evolve and become great places for people to work in and with. 
Having worked with a wide variety of clients from school-age students to senior executives, she has been designing and running workshops, seminars and classes in person or via web events since she left long commutes and corporate roles behind in 2014 when she created her first two businesses. Her passion is in improving working relationships between roles and functions, supporting people to discover how to be their best selves at work. She does this in the auto-motive industry, financial services, medical teams, charities, global media, retail, education systems and the arts.
When she’s not working, she and her classic car Monty Morgan can be found zipping around the English countryside.
Kate's training & qualifications
CTI Co-Active certified coach, ICF registered (CPCC) (PCC)
Coach supervisor (ESQA) (EMCC)
Lean Six Sigma Black Belt
Lumina Sparks practitioner
Hay Group Leadership Styles & Climate accredited coach
Human Capital Institute certified in human capital strategy
Sheppard Moscow advanced business consulting
Conflict management trained (Thomas-Kilman instrument)
Chartered Institute of Marketing Diploma



So, will you be joining us? 🤔
See what our attendees said here. 



Own Your Success

Leadership

Business Leadership

Administrative Assistant

Career Development

Leadership Skills

Personal Assistant

Leadership Development

Executive Assistant

Corporate Learning & Development

Ethical Leadership

Discover how to elevate your career as an executive assistant or personal assistant with our comprehensive EA Mastery Workshop. Gain new skills, strategies, and tools to maximize your impact and achieve success.

EA/PA Excellence Workshop Virtual

Early release

General release

Last Remaining Seats

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Aims:&nbsp;To develop the exercise professional&rsquo;s understanding of mental health conditions and the benefits of activity and positive lifestyle behaviours.Outcome:&nbsp;You will be able to plan, deliver, and evaluate activity sessions in the community and/or clinical settings with clients with a range of mental health conditions.Qualification Structure:<ol start="1" type="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Learners will cover:<ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Key mental health conditions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The relationships between mental health, society and lifestyle</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Legislation and government policy relating to mental health</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The role of national organisations relating to mental health</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Roles and boundaries of the people involved in programming physical activity for individuals with mental health conditions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to motivate and support individuals with mental health conditions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to evaluate the usefulness of a range of resources of information on mental health and its relationship to physical activity</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to evaluate the effectiveness of a range of mental health interventions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to program physical activity for individuals with mental health conditions How to deliver physical activity programmes to individuals with mental health conditions</li></ul></ol><div fr-original-style="" style="box-sizing: border-box;">Entry Requirements:</div><div fr-original-style="" style="box-sizing: border-box;">We recommend you hold an Exercise Referral Qualification</div><div fr-original-style="" style="box-sizing: border-box;"> </div><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Assessments:</div>Theory paperResearch worksheetAnalysis taskKnowledge questionsProgramme designProgramme deliveryProfessional discussion (programme delivery)Evaluation of programme delivery</div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"> </div>

Aims: To develop the exercise professional’s understanding of mental health conditions and the benefits of activity and positive lifestyle behaviours.
Outcome: You will be able to plan, deliver, and evaluate activity sessions in the community and/or clinical settings with clients with a range of mental health conditions.
Qualification Structure:
Learners will cover:
Key mental health conditions
The relationships between mental health, society and lifestyle
Legislation and government policy relating to mental health
The role of national organisations relating to mental health
Roles and boundaries of the people involved in programming physical activity for individuals with mental health conditions
How to motivate and support individuals with mental health conditions
How to evaluate the usefulness of a range of resources of information on mental health and its relationship to physical activity
How to evaluate the effectiveness of a range of mental health interventions
How to program physical activity for individuals with mental health conditions How to deliver physical activity programmes to individuals with mental health conditions
Entry Requirements:We recommend you hold an Exercise Referral QualificationAssessments:
Theory paper
Research worksheet
Analysis task
Knowledge questions
Programme design
Programme delivery
Professional discussion (programme delivery)
Evaluation of programme delivery

Health

Aims: To develop the exercise professional’s understanding of mental health conditions and the benefits of activity and positive lifestyle behaviours.

Outcome: You will be able to plan, deliver, and evaluate activity sessions in the community and/or clinical settings with clients with a range of mental health conditions.

YMCA Level 4 Certificate in Delivering Physical Activity for Individuals with Mental Health Conditions

Bournemouth

London Waterloo Academy

Dental Nurse

Dental Assistant

VIRTUAL DENTAL NURSING DIPLOMA

Registration Fee

Tuition Fee

Exam Fee

One Day Introduction Course

The Training in Fluoride Application is segmented into two core components. First, it delves into the theoretical understanding of various subjects, encompassing patient management, community-based fluoride application programs, and broader topics like legal and ethical considerations. The second component is practical, requiring students to maintain a work-based record of competence, integral to their learning journey.<a href="https://www.nebdn.org/" style="color: var(--color-link-text); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--color-link-text);"><img src="https://cavitytraining.co.uk/app/uploads/2024/03/logo-nebdn-300x167.png" alt="" width="300" height="167" srcset="https://cavitytraining.co.uk/app/uploads/2024/03/logo-nebdn-300x167.png 300w, https://cavitytraining.co.uk/app/uploads/2024/03/logo-nebdn-1024x571.png 1024w, https://cavitytraining.co.uk/app/uploads/2024/03/logo-nebdn-768x428.png 768w, https://cavitytraining.co.uk/app/uploads/2024/03/logo-nebdn-1536x856.png 1536w, https://cavitytraining.co.uk/app/uploads/2024/03/logo-nebdn-2048x1141.png 2048w, https://cavitytraining.co.uk/app/uploads/2024/03/logo-nebdn-1640x914.png 1640w, https://cavitytraining.co.uk/app/uploads/2024/03/logo-nebdn-1280x713.png 1280w, https://cavitytraining.co.uk/app/uploads/2024/03/logo-nebdn-640x357.png 640w, https://cavitytraining.co.uk/app/uploads/2024/03/logo-nebdn-320x178.png 320w" sizes="(max-width: 300px) 100vw, 300px" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></a> <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;">Learn about the Cavity Training Fluoride Varnish Application CourseThe Certificate in Fluoride Varnish Application is a level 4 post- registration qualification awarded by the National Examination Board for Dental Nurses (NEBDN). This provides established dental nurses with additional training which will enable them to provide effective fluoride varnish application within a community-based setting, on prescription from a dentist or as part of a structured dental health program.<div fr-original-style="" style="box-sizing: border-box;"> </div><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;">Frequently Asked Questions How long is the course?The course duration is 6 months. When are the classes held?You will attend online/remote lessons via Teams. One 3 hour lesson each month for 6 months. Is there an exam at the end?There is no exam at the end, you need to successfully complete a Record of Competence. <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;"><article style="color: rgb(28, 28, 28); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(28, 28, 28);"><h3 style="color: var(--color-heading-text); box-sizing: border-box;" fr-original-style=" color: var(--color-heading-text);">Course Dates</h3><ul style="color: var(--color-body-text); box-sizing: border-box;" fr-original-style=" color: var(--color-body-text);"><li fr-original-style="" style="box-sizing: border-box;">18th April 2024 9:30am - 12:00pm</li><li fr-original-style="" style="box-sizing: border-box;">20th April 2024 10:30am - 1:00pm</li><li fr-original-style="" style="box-sizing: border-box;">6th June 2024 9:30am - 12:00pm</li><li fr-original-style="" style="box-sizing: border-box;">12th October 2024 10:30am - 1:00pm</li><li fr-original-style="" style="box-sizing: border-box;">17th October 2024 9:30am - 12:00pm</li></ul></article><article style="color: rgb(28, 28, 28); box-sizing: border-box;" fr-original-style=" color: rgb(28, 28, 28);"><h3 style="color: var(--color-heading-text); box-sizing: border-box;" fr-original-style=" color: var(--color-heading-text);">Costs</h3>&pound;695.00 per person (inc. VAT)Course Fee is &pound;600 + &pound;95.00 Fee for Certificate (No Exam).Please choose from one of the course dates above.</article>

Cavity Dental Training

Certificate in Fluoride Varnish Application

8744 Courses delivered Online

Learn MySQL from Scratch for Data Science and Analytics

By Studyhub UK

Real Estate Agent

By Studyhub UK

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

By Studyhub UK

Website Hacking From Scratch

By Studyhub UK

Ethereum Blockchain DApp using Solidity

By Studyhub UK

Certificate in Medical Coding- ICD-10-CM at QLS Level 3

By Studyhub UK

Deep Learning & Neural Networks Python - Keras

By Studyhub UK

HTML and CSS Coding: Beginner to Advanced

By Studyhub UK

Diploma in CompTIA A+

By Studyhub UK

Electrical Engineering With Electric Circuits

By Studyhub UK