<div id="course-pills-1">Duration3 Days18 CPD hoursThis course is intended forData Wrangling with Python takes a practical approach to equip beginners with the most essential data analysis tools in the shortest possible time. It contains multiple activities that use real-life business scenarios for you to practice and apply your new skills in a highly relevant context.OverviewBy the end of this course, you will be confident in using a diverse array of sources to extract, clean, transform, and format your data efficiently.In this course you will start with the absolute basics of Python, focusing mainly on data structures. Then you will delve into the fundamental tools of data wrangling like NumPy and Pandas libraries. You'll explore useful insights into why you should stay away from traditional ways of data cleaning, as done in other languages, and take advantage of the specialized pre-built routines in Python.This combination of Python tips and tricks will also demonstrate how to use the same Python backend and extract/transform data from an array of sources including the Internet, large database vaults, and Excel financial tables. To help you prepare for more challenging scenarios, you'll cover how to handle missing or wrong data, and reformat it based on the requirements from the downstream analytics tool. The course will further help you grasp concepts through real-world examples and datasets.</div><div id="course-pills-2"><h4>Introduction to Data Structure using Python</h4><ul><li>Python for Data Wrangling</li><li>Lists, Sets, Strings, Tuples, and Dictionaries</li></ul><h4>Advanced Operations on Built-In Data Structure</h4><ul><li>Advanced Data Structures</li><li>Basic File Operations in Python</li></ul><h4>Introduction to NumPy, Pandas, and Matplotlib</h4><ul><li>NumPy Arrays</li><li>Pandas DataFrames</li><li>Statistics and Visualization with NumPy and Pandas</li><li>Using NumPy and Pandas to Calculate Basic Descriptive Statistics on the DataFrame</li></ul><h4>Deep Dive into Data Wrangling with Python</h4><ul><li>Subsetting, Filtering, and Grouping</li><li>Detecting Outliers and Handling Missing Values</li><li>Concatenating, Merging, and Joining</li><li>Useful Methods of Pandas</li></ul><h4>Get Comfortable with a Different Kind of Data Sources</h4><ul><li>Reading Data from Different Text-Based (and Non-Text-Based) Sources</li><li>Introduction to BeautifulSoup4 and Web Page Parsing</li></ul><h4>Learning the Hidden Secrets of Data Wrangling</h4><ul><li>Advanced List Comprehension and the zip Function</li><li>Data Formatting</li></ul><h4>Advanced Web Scraping and Data Gathering</h4><ul><li>Basics of Web Scraping and BeautifulSoup libraries</li><li>Reading Data from XML</li></ul><h4>RDBMS and SQL</h4><ul><li>Refresher of RDBMS and SQL</li><li>Using an RDBMS (MySQL/PostgreSQL/SQLite)</li></ul><h4>Application in real life and Conclusion of course</h4><ul><li>Applying Your Knowledge to a Real-life Data Wrangling Task</li><li>An Extension to Data Wrangling</li></ul></div>

Nexus Human

Data Engineering

Big Data Analytics

Data Science

Data Skills

Data Analyst

Data Processing

Data Wrangling with Python

Ei4Change

Mindfulness

Emotional Wellbeing

Emotional Intelligence (EQ)

Leadership Skills

Psychological Wellbeing

Emotional Resilience

Mental Resilience

Resilience

Influencing Skills

How to inspire others and build successful relationships.

This course is designed to support professionals in business to develop communication skills through understanding and applying knowledge of personality and behaviour in the workplace.  It is based upon the book "The Authority Guide to Behaviour in Business: How to Inspire Others and Build Successful Relationships" by Robin Hills  (ISBN: 1912300087).

Influencing with Behavioural Styles

General Admission

<div>
	<h3>Description:</h3>
In the 21st century, web design is one of the most influential aspects of your online presence. HTML 5, and CSS 3 are the primary foundations of the websites. And with the help of Bootstrap, you will be able to design and develop responsive websites.
Master the advanced techniques of HTML 5, CSS 3, and Bootstrap for designing attractive and professional web pages by enrolling in the Diploma in Web Design (HTML5 CSS3 and Bootstrap) course.
With our comprehensive course, get started on the journey to web designing. Explore the strategies of developing fascinating websites using HTML 5, and CSS 3 and make your websites responsive using Bootstrap. Additionally, you will look at some general rules to keep in mind while designing web pages.
Upon completion, you will be able to design any types of websites using HTML 5, CSS 3, and Bootstrap.
<h3>Who is the course for?</h3>
<ul>
<li>Absolute beginners who want to learn the first building blocks (HTML &amp; CSS) for creating websites</li>
<li>Anyone with a website that wants to be able to customize it with HTML and CSS to make it look like you imagine</li>
<li>Anyone looking for a quick refresher of how HTML, CSS, and Bootstrap works</li>
</ul>
<h3>Entry Requirement:</h3>
<ul>
<li>This course is available to all learners, of all academic backgrounds.</li>
<li>Learners should be aged 16 or over to undertake the qualification.</li>
<li>Good understanding of English language, numeracy and ICT are required to attend this course.</li>
</ul>
<h3>Certification:</h3>
After completing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
<h3>Why choose us?</h3>
<ul>
<li>Affordable, engaging &amp; high-quality e-learning study materials;</li>
<li>Tutorial videos/materials from the industry leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>The UK &amp; internationally recognised accredited qualification;</li>
<li>Access to course content on mobile, tablet or desktop from anywhere anytime;</li>
<li>The benefit of career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path:</h3>
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Welcome</td>
				</tr>
								<tr>
					<td></td>
					<td>1.1 Intro</td>
					<td>FREE </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>1.2 Install the Tools and Get Started</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">HTML 5</td>
				</tr>
								<tr>
					<td></td>
					<td>2.1 Intro to HTML</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.2 What is HTML</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.3 Start a New HTML File &amp; Use Tags</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.4 Header Tags</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.5 Edit Text</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.6 Links</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.7 Images</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.8 Lists</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.9 Challenge 1</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.10 HTML Outro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">CSS 3</td>
				</tr>
								<tr>
					<td></td>
					<td>3.1 CSS Intro</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.2 Add CSS Styles</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.3 Classes and IDs</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.4 Borders</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.5 Sizing</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.6 Padding and Margin</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.7 Text Styles</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.8 DIVs</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.9 Postioning</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.10 Hover</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.11 Easily Center Elements</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.12 Fonts</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.13 Challenge</td>
					<td> </td>
					<td> 00:23:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.14 CSS Outro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Bootstrap</td>
				</tr>
								<tr>
					<td></td>
					<td>4.1 Intro to Bootstrap</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.2 Install Bootstrap</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.3 Indenting and Containers</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.4 The Grid System</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.5 Images</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.6 Buttons</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.7 Challenge 3</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.8 Bootstrap Outro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Project 1 - Design a Landing Page</td>
				</tr>
								<tr>
					<td></td>
					<td>5.1 Landing Page Intro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.2 Sketch Your Landing Page</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.3 The Top Section</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.4 Polish the Top Section</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.5 Adding Images</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.6 The Main Points Section</td>
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.7 Collecting Emails With an Opt-In Form</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.8 Challenge 4</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.9 Landing Page Outro</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Project 2 - Business Website</td>
				</tr>
								<tr>
					<td></td>
					<td>6.1 Business Site Intro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.2 Sketch Up</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.3 Using Fancy Font Logo</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.4 Carousel Basics</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.5 Carousel Extras</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.6 Text on Images</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.7 Phone Number Icon</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.8 Google Maps</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.9 Font Awesome</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.10 Challenge 4</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.11 Business Site Outro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Project 3 - Portfolio</td>
				</tr>
								<tr>
					<td></td>
					<td>7.1 Intro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>7.2 Portfolio Sketch</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>7.3 Jumbotron</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>7.4 Nav Bar</td>
					<td> </td>
					<td> 00:24:00</td>
				</tr>
								<tr>
					<td></td>
					<td>7.5 Panels</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>7.6 Challenge 5</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>7.7 Portfolio Outre</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Hosting - Getting Your Website on the Internet</td>
				</tr>
								<tr>
					<td></td>
					<td>8.1 Hosting</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>8.2 Bluehost</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>8.3 Uploading</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>8.4 Tips</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>8.5 Hosting Outro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

John Academy

Online Course Creation

HTML & CSS

Web Designer

Website Design

Web Development

Web Design

Diploma in Web Design (HTML5 CSS3 and Bootstrap)

NextGen Learning

Data Science & Machine Learning with Python Course

Packt

JavaScript

Automation Testing

Node.js

Cypress

Python

Programming

This course is perfect for quality assurance professionals who want to step into automation testing with Cypress. You will learn Cypress from scratch and become a specialist in building a solid Cypress automation framework to test any real-world web application.

Cypress - Modern Automation Testing from Scratch + Framework

Data analysis is a crucial skill in today's data-driven world, and the demand for skilled data analysts in the UK is on the rise. According to the Office for National Statistics (ONS), the UK's digital economy grew by 7.9% in this year, creating numerous job opportunities in fields such as data analysis.In Data Analysis in Excel with Analytics for Data Analysts course, you will get to learn the fundamentals of Excel data analysis. The highly informative modules will help you enhance your understanding of charts, pivot tables, pivot charts and more. You will acquire the expertise to work with multiple workbooks and worksheets. In this step-by-step learning process, you will get to grasp a better understanding of lookup functions. In addition, you will know the essentials of data forecasting, mapping data and formula auditing.At the end of the data analysis course, you can receive QLS endorsed certificate of achievement. This certificate will allow you to enhance your resume and lift your employability. Enrol now!Dis Diploma Included Courses are: <ul><li>Course 01: Diploma in Data Analytics with Tableau </li><li>Course 02: Data Analytics </li><li>Course 03: Google Data Studio: Data Analytics </li><li>Course 04: Big Data Analytics with PySpark Tableau Desktop and MongoDB </li><li>Course 05: Learn MySQL from Scratch for Data Science and Analytics </li><li>Course 06: Data Analysis In Excel </li><li>Course 07: Diploma in Data Analysis Fundamentals </li><li>Course 08: Business Data Analysis </li><li>Course 09: Data Science &amp; Machine Learning with Python </li><li>Course 10: R Programming for Data Science </li><li>Course 11: Learn Python, JavaScript, and Microsoft SQL for Data science</li></ul>Key Learnings:<ul><li>Ability to effectively modify and organize data within a worksheet using various formatting tools.</li><li>Proficiency in working with lists and using data analysis techniques such as sorting, filtering, and subtotalling.</li><li>Competency in analysing data through the use of functions, such as statistical and mathematical functions, to derive meaningful insights.</li><li>Proficiency in creating visually appealing charts and graphs to effectively communicate data insights.</li><li>Competency in using PivotTables and PivotCharts to efficiently summarize and analyse large sets of data.</li><li>Proficiency in automating data analysis tasks and functions through the use of macros and other automated workbook functionalities.</li></ul>Course Significant Points:<ul><li>Quality Licence Scheme Endorsed</li><li>CPD Accredited Course</li><li>Unlimited Retake Exam &amp; Tutor Support</li><li>Easy Accessibility to the Course Materials</li><li>100% Learning Satisfaction Guarantee</li><li>Lifetime Access &amp; 24/7 Support</li><li>Self-paced online course Modules</li><li>Covers to Explore Multiple Job Positions</li></ul>How is the course assessed?To assess your learning, you have to complete the assignment questions provided at the end of the course. You have to score at least 60% to pass the exam and to qualify for Quality Licence Scheme endorsed and CPD-accredited certificates. After passing the assignment exam, you will be able to apply for a certificate.Meet the EndorsementThe Quality Licence Scheme has been designed specifically to recognise high-quality courses. This Data Analysis with Excel course materials are recognised by Quality Licence Scheme (QLS). This ensures the deep research and quality resource allocation behind the development phase of the course. In addition, the QLS certificate enriches your CV and recognises your quality study on the relevant subject.How will QLS boost your worth?<ul><li>Achieving Quality Licence Scheme endorsed certificates can provide you with valued and credible evidence of your skills and knowledge to potential employers. </li><li>Quality Licence Scheme (QLS) endorsements are awarded to training programmes and courses that meet high quality standards, ensuring that your certificate represents a valuable achievement.</li><li>The stringent assessment process involved in achieving Quality Licence Scheme Endorsed Certificates ensures that you have acquired the necessary skills and knowledge to excel in your chosen field.</li></ul>Meet the AccreditationCPD Quality Standards (CPD QS) accreditation assures the Data Analysis with Excel course training and learning activities are relevant, reliable, and up to date.How Will CPD Accredited Value You?<ul><li>CPD accreditation ensures that the training programme or course you have completed has been independently reviewed and meets rigorous quality standards.</li><li>By achieving CPD accredited certificates, you can enhance your career prospects, build your professional reputation, and stay competitive in today's job market.</li></ul>**Diploma in Data Analytics with Tableau**<ul><li>Introduction To The Course</li><li>Project 1: Discount Mart (Sales And Profit Analytics)</li><li>Project 2: Green Destinations (HR Analytics)</li><li>Project 3: Superstore (Sales Agent Tracker)</li><li>Northwind Trade (Shipping Analytics)</li><li>Project 5: Tesla (Stock Price Analytics)</li><li>Bonus: Introduction To Database Concepts</li><li>Tableau Stories</li></ul>**Data Analytics**<ul><li>Introduction To The World Of Data</li><li>Basics Of Data Analytics</li><li>Statistics For Data Analytics</li><li>Actions Taken In The Data Analysis Process</li><li>Gathering The Right Information</li><li>Storing Data</li><li>Data Mining</li><li>Excel For Data Analytics</li><li>Tools For Data Analytics</li><li>Data-Analytic Thinking</li><li>Data Visualisation That Clearly Describes Insights</li><li>Data Visualisation Tools</li></ul>**Google Data Studio: Data Analytics**<ul><li>Introduction</li><li>Google Sheets</li><li>Google Data Studio</li></ul>**Big Data Analytics with PySpark Tableau Desktop and MongoDB**<ul><li>Introduction</li><li>Setup And Installations</li><li>Data Processing With PySpark And MongoDB</li><li>Machine Learning With PySpark And MLlib</li><li>Creating The Data Pipeline Scripts</li><li>Tableau Data Visualization</li><li>Source Code</li></ul>**Learn MySQL from Scratch for Data Science and Analytics**<ul><li>Getting Started</li><li>SQL Server Setting Up</li><li>SQL Database Basics</li><li>SQL DML (Data Manipulation Language)</li><li>SQL DDL (Data Definition Language)</li><li>SQL DCL (Data Control Language)</li><li>SQL Statement Basic</li><li>Filtering Data Rows</li><li>Aggregate Functions For Data Analysis</li><li>SQL Data Analyticstatements</li><li>SQL Group By Statement</li><li>JOINS</li><li>SQL Constraints</li><li>Views</li><li>Advanced SQL Functions</li><li>SQL Stored Procedures</li><li>Import &amp; Export Data</li><li>Backup And Restore Database</li></ul>**Data Analysis In Excel**<ul><li>Modifying A Worksheet</li><li>Working With Lists</li><li>Analyzing Data</li><li>Visualizing Data With Charts</li><li>Using PivotTables And PivotCharts</li><li>Working With Multiple Worksheets And Workbooks</li><li>Using Lookup Functions And Formula Auditing</li><li>Automating Workbook Functionality</li><li>Creating Sparklines And Mapping Data</li><li>Forecasting Data</li></ul>**Diploma in Data Analysis Fundamentals**<ul><li>Introduction</li><li>Agenda And Principles Of Process Management</li><li>The Voice Of The Process</li><li>Working As One Team For Improvement</li><li>Exercise: The Voice Of The Customer</li><li>Tools For Data Analysis</li><li>The Pareto Chart</li><li>The Histogram</li><li>The Run Chart</li><li>Exercise: Presenting Performance Data</li><li>Understanding Variation</li><li>The Control Chart</li><li>Control Chart Example</li><li>Control Chart Special Cases</li><li>Interpreting The Control Chart</li><li>Control Chart Exercise</li><li>Strategies To Deal With Variation</li><li>Using Data To Drive Improvement</li><li>A Structure For Performance Measurement</li><li>Data Analysis Exercise</li><li>Course Project</li><li>Test Your Understanding</li></ul>**Business Data Analysis**<ul><li>Introduction To Business Analysis</li><li>Business Environment</li><li>Business Processes</li><li>Business Analysis Planning And Monitoring</li><li>Strategic Analysis And Product Scope</li><li>Solution Evaluation</li><li>Investigation Techniques</li><li>Ratio Analysis</li><li>Stakeholder Analysis And Management</li><li>Process Improvement With Gap Analysis</li><li>Documenting And Managing Requirements</li><li>Business Development And Succession Planning</li><li>Planning &amp; Forecasting Operations</li><li>Business Writing Skills</li></ul>**Data Science &amp; Machine Learning with Python**<ul><li>Course Overview &amp; Table Of Contents</li><li>Introduction To Machine Learning</li><li>System And Environment Preparation</li><li>Learn Basics Of Python - Assignment</li><li>Learn Basics Of Python - Functions</li><li>Learn Basics Of Python - Data Structures</li><li>Learn Basics Of NumPy - NumPy Array</li><li>Learn Basics Of NumPy - NumPy Data</li><li>Learn Basics Of NumPy - NumPy Arithmetic</li><li>Learn Basics Of Matplotlib</li><li>Learn Basics Of Pandas</li><li>Understanding The CSV Data File</li><li>Load And Read CSV Data File Using Python Standard Library</li><li>Load And Read CSV Data File Using NumPy</li><li>Load And Read CSV Data File Using Pandas</li><li>Dataset Summary - Peek, Dimensions And Data Types</li><li>Dataset Summary - Class Distribution And Data Summary</li><li>Dataset Summary - Explaining Correlation</li><li>Dataset Summary - Explaining Skewness - Gaussian And Normal Curve</li><li>Dataset Visualization - Using Histograms</li><li>Dataset Visualization - Using Density Plots</li><li>Dataset Visualization - Box And Whisker Plots</li><li>Multivariate Dataset Visualization - Correlation Plots</li><li>Multivariate Dataset Visualization - Scatter Plots</li><li>Data Preparation (Pre-Processing) - Introduction <ul><li>Re-Scaling Data</li><li>Standardizing Data</li><li>Normalizing Data</li><li>Binarizing Data</li></ul></li><li>Feature Selection - Introduction <ul><li>Uni-Variate Part</li><li>Recursive Feature Elimination</li><li>Principal Component Analysis (PCA)</li><li>Feature Importance</li></ul></li><li>Refresher Session - The Mechanism Of Re-Sampling, Training And Testing</li><li>Algorithm Evaluation Techniques - Introduction <ul><li>Train And Test Set</li><li>K-Fold Cross Validation</li><li>Leave One Out Cross Validation</li><li>Repeated Random Test-Train Splits</li></ul></li><li>Algorithm Evaluation Metrics - Introduction <ul><li>Classification Accuracy</li><li>Log Loss</li><li>Area Under ROC Curve</li><li>Confusion Matrix</li><li>Classification Report</li><li>Mean Absolute Error - Dataset Introduction</li><li>Mean Absolute Error</li><li>Mean Square Error</li><li>R Squared</li></ul></li><li>Classification Algorithm Spot Check - Logistic Regression <ul><li>Linear Discriminant Analysis</li><li>K-Nearest Neighbors</li><li>Naive Bayes</li><li>CART</li><li>Support Vector Machines</li></ul></li><li>Regression Algorithm Spot Check - Linear Regression <ul><li>Ridge Regression</li><li>Lasso Linear Regression</li><li>Elastic Net Regression</li><li>K-Nearest Neighbors</li><li>CART</li><li>Support Vector Machines (SVM)</li></ul></li><li>Compare Algorithms</li><li>Pipelines</li><li>Performance Improvement: Ensembles - Voting <ul><li>Bagging</li><li>Boosting</li></ul></li><li>Performance Improvement: Parameter Tuning Using Grid Search</li><li>Performance Improvement: Parameter Tuning Using Random Search</li><li>Export, Save And Load Machine Learning Models : Pickle</li><li>Export, Save And Load Machine Learning Models : Joblib</li><li>Finalizing A Model - Introduction And Steps</li><li>Finalizing A Classification Model - The Pima Indian Diabetes Dataset</li><li>Quick Session: Imbalanced Data Set - Issue Overview And Steps</li><li>Iris Dataset : Finalizing Multi-Class Dataset</li><li>Finalizing A Regression Model - The Boston Housing Price Dataset</li><li>Real-Time Predictions: Using The Pima Indian Diabetes Classification Model</li><li>Real-Time Predictions: Using Iris Flowers Multi-Class Classification Dataset</li><li>Real-Time Predictions: Using The Boston Housing Regression Model</li></ul>**R Programming for Data Science**<ul><li>Data Science Overview</li><li>R And RStudio</li><li>Introduction To Basics</li><li>Vectors</li><li>Matrices</li><li>Factors</li><li>Data Frames</li><li>Lists</li><li>Relational Operators</li><li>Logical Operators</li><li>Conditional Statements</li><li>Loops</li><li>Functions</li><li>R Packages</li><li>The Apply Family - Lapply</li><li>The Apply Family - Sapply &amp; Vapply</li><li>Useful Functions</li><li>Regular Expressions</li><li>Dates And Times</li><li>Getting And Cleaning Data</li><li>Plotting Data In R</li><li>Data Manipulation With Dplyr</li></ul>**Learn Python, JavaScript, and Microsoft SQL for Data science**<ul><li>JavaScript Introduction</li><li>JavaScript Basics</li><li>JavaScript Operators</li><li>JavaScript Conditional Statements</li><li>JavaScript Control Flow Statements</li><li>JavaScript Functions</li><li>JavaScript Error Handling</li><li>JavaScript Client-Side Validations</li><li>Python Introduction</li><li>Python Basic</li><li>Python Strings</li><li>Python Operators</li><li>Python Data Structures</li><li>Python Conditional Statements</li><li>Python Control Flow Statements</li><li>Python Core Games</li><li>Python Functions</li><li>Python Args, KW Args For Data Science</li><li>Python Project</li><li>Python Object Oriented Programming [OOPs]</li><li>Python Methods</li><li>Python Class And Objects</li><li>Python Inheritance And Polymorphism</li><li>Python Encapsulation And Abstraction</li><li>Python OOPs Games</li><li>Python Modules And Packages</li><li>Python Error Handling</li><li>Microsoft SQL[MS] Introduction</li><li>MS SQL Statements</li><li>MS SQL Filtering Data</li><li>MS SQL Functions</li><li>MS SQL Joins</li><li>MS SQL Advanced Commands</li><li>MS SQL Structure And Keys</li><li>MS SQL Queries</li><li>MS SQL Structure Queries</li><li>MS SQL Constraints</li><li>MS SQL Backup And Restore</li></ul><h2>
 
 <div>CPD</div>
 </h2>

 <div id="cpd">
 <div>
 <div>
 <div>
 570 CPD hours / points
 </div>
 <div>
 Accredited by CPD Quality Standards
 </div>
 </div>
 </div>
 </div><h2>
 
 <div>Who is this course for?</div>
 </h2>

 <div id="who_is_this_course_for">
 Data Analysis course is ideal for: <ul><li>Professionals working in fields such as finance, business, and healthcare who need to analyse data and make decisions based on their findings.</li><li>Students and researchers who want to develop their skills in data analysis and visualisation using Excel.</li><li>Individuals who are looking to pursue a career in data analysis and want to gain a foundational understanding of Excel and its capabilities.</li><li>Business owners and entrepreneurs who want to learn how to use Excel to analyse and interpret data for their own businesses.</li><li>Anyone who wants to improve their data analysis skills for personal or professional purposes and gain proficiency in Excel as a tool for data analysis.</li></ul>
 </div><h2>
 
 <div>Requirements</div>
 </h2>

 <div id="requirements">
 There are no specific prerequisites to enrol in Data analysis course. Anyone and everyone can take this course.
 </div><h2>
 
 <div>Career path</div>
 </h2>

 <div id="career_path">
 The course will assist you in establishing a solid understanding of data analysis. After the course, you will be able to explore career options such as:<ul><li>Data Analyst (Average annual salary £35,000)</li><li>Research Analyst (Average annual salary £28,552)</li><li>Business Analyst (Average annual salary £42,618)</li><li>Risk Analyst (Average annual salary £41,340)</li><li>Financial Analyst (Average annual salary £50,300)</li></ul>
 </div><h2>
 
 <div>Certificates</div>
 </h2>

 <div id="optional_extras">
 <h4>Certificate of completion (PDF)</h4>
 
 Digital certificate -
 £9
 
 <div> CPD Accredited PDF Certificate. A PDF Certificate: £9 </div>
 <h4>Certificate of completion (Hardcopy)</h4>
 
 Hard copy certificate -
 £15
 
 <div> CPD Accredited Hard Copy Certificate. A Hardcopy Certificate (within the UK): £15 A Hardcopy Certificate (international): £15 + £10 (postal charge) = £25 </div>
 <h4>Endorsed Certificate of Achievement from the Quality Licence Scheme (Hardcopy)</h4>
 
 Hard copy certificate -
 £109
 
 <div> Data Analysis In Excel (within the UK: £109, International: £119) </div>

 </div>

One Education

Data Analyst : Data Analyst (Data Analytics) - Level 5 Diploma Course

The course helps you learn how to program with Python without any prior experience. The course also emphasizes learning the Django framework. You'll work on 4 major projects that will ensure that you have acquired and implemented your newly added skills to make Python-based websites with Django.

The Complete Python Course including the Django Web Framework

<div>
	<h3>Description:</h3>
In the 21st century, web design is one of the most influential aspects of your online presence. HTML 5, and CSS 3 are the primary foundations of the websites. And with the help of Bootstrap, you will be able to design and develop responsive websites.
Master the advanced techniques of HTML 5, CSS 3, and Bootstrap for designing attractive and professional web pages by enrolling in the The Complete Web Design Course course.
With our comprehensive course, get started on the journey to web designing. Explore the strategies of developing fascinating websites using HTML 5, and CSS 3 and make your websites responsive using Bootstrap. Additionally, you will look at some general rules to keep in mind while designing web pages.
Upon completion, you will be able to design any types of websites using HTML 5, CSS 3, and Bootstrap.
<h3>Who is the course for?</h3>
<ul>
<li>Absolute beginners who want to learn the first building blocks (HTML &amp; CSS) for creating websites</li>
<li>Anyone with a website that wants to be able to customize it with HTML and CSS to make it look like you imagine</li>
<li>Anyone looking for a quick refresher of how HTML, CSS, and Bootstrap works</li>
</ul>
<h3>Entry Requirement:</h3>
<ul>
<li>This course is available to all learners, of all academic backgrounds.</li>
<li>Learners should be aged 16 or over to undertake the qualification.</li>
<li>Good understanding of English language, numeracy and ICT are required to attend this course.</li>
</ul>
<h3>Assessment:</h3>
<ul>
<li>At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.</li>
<li>Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam.</li>
</ul>
<h3>Certification:</h3>
After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
<h3>Why choose us?</h3>
<ul>
<li>Affordable, engaging &amp; high-quality e-learning study materials;</li>
<li>Tutorial videos/materials from the industry leading experts;</li>
<li>Study in a user-friendly, advanced online learning platform;</li>
<li>Efficient exam systems for the assessment and instant result;</li>
<li>The UK &amp; internationally recognised accredited qualification;</li>
<li>Access to course content on mobile, tablet or desktop from anywhere anytime;</li>
<li>The benefit of career advancement opportunities;</li>
<li>24/7 student support via email.</li>
</ul>
<h3>Career Path:</h3>
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Welcome</td>
				</tr>
								<tr>
					<td></td>
					<td>1.1 Intro</td>
					<td>FREE </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>1.2 Install the Tools and Get Started</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">HTML 5</td>
				</tr>
								<tr>
					<td></td>
					<td>2.1 Intro to HTML</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.2 What is HTML</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.3 Start a New HTML File &amp; Use Tags</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.4 Header Tags</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.5 Edit Text</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.6 Links</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.7 Images</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.8 Lists</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.9 Challenge 1</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>2.10 HTML Outro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">CSS 3</td>
				</tr>
								<tr>
					<td></td>
					<td>3.1 CSS Intro</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.2 Add CSS Styles</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.3 Classes and IDs</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.4 Borders</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.5 Sizing</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.6 Padding and Margin</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.7 Text Styles</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.8 DIVs</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.9 Postioning</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.10 Hover</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.11 Easily Center Elements</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.12 Fonts</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.13 Challenge</td>
					<td> </td>
					<td> 00:23:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3.14 CSS Outro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Bootstrap</td>
				</tr>
								<tr>
					<td></td>
					<td>4.1 Intro to Bootstrap</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.2 Install Bootstrap</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.3 Indenting and Containers</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.4 The Grid System</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.5 Images</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.6 Buttons</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.7 Challenge 3</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>4.8 Bootstrap Outro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Project 1 - Design a Landing Page</td>
				</tr>
								<tr>
					<td></td>
					<td>5.1 Landing Page Intro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.2 Sketch Your Landing Page</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.3 The Top Section</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.4 Polish the Top Section</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.5 Adding Images</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.6 The Main Points Section</td>
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.7 Collecting Emails With an Opt-In Form</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.8 Challenge 4</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>5.9 Landing Page Outro</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Project 2 - Business Website</td>
				</tr>
								<tr>
					<td></td>
					<td>6.1 Business Site Intro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.2 Sketch Up</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.3 Using Fancy Font Logo</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.4 Carousel Basics</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.5 Carousel Extras</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.6 Text on Images</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.7 Phone Number Icon</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.8 Google Maps</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.9 Font Awesome</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.10 Challenge 4</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>6.11 Business Site Outro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Project 3 - Portfolio</td>
				</tr>
								<tr>
					<td></td>
					<td>7.1 Intro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>7.2 Portfolio Sketch</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>7.3 Jumbotron</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>7.4 Nav Bar</td>
					<td> </td>
					<td> 00:24:00</td>
				</tr>
								<tr>
					<td></td>
					<td>7.5 Panels</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>7.6 Challenge 5</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>7.7 Portfolio Outre</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Hosting - Getting Your Website on the Internet</td>
				</tr>
								<tr>
					<td></td>
					<td>8.1 Hosting</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>8.2 Bluehost</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>8.3 Uploading</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>8.4 Tips</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>8.5 Hosting Outro</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table>

Online Course Marketing

The Complete Web Design Course

This course introduces you to the paradigm and features of object-oriented programming using Java, an object-oriented language popular in the industry and IntelliJ. The course entails modeling objects and classes, object-oriented facilities like inheritance and polymorphism, native data structures, exception handling, file management, and streams.
 Java is a high-level, class-based OOP language developed as a general-purpose programming language intended to write once and run anywhere (WORA). Compiled Java code can run on all platforms without the need to recompile.

This course has been delivered over four modules. Module 1 explores the Java Development Cycle and allows us to differentiate between JDK versions and development tools. You will learn about operators and basic syntax and write a simple program. In module 2, The concepts covered include strings, string methods, StringBuilder, data flow diagrams, decision-making, loops, arrays, and simple programs. Module 3 delves into classes and objects, inheritance and polymorphism, Lambdas, and exception handling. Finally, over module 4, we will work on two UML case studies, including the ATM simulation and Employee payroll system. We will also learn about version control and GitHub integration of the projects developed.

Upon completion of the course, you will gain comprehensive Java programming knowledge and be able to write complex codes in a real-world scenario independently. You will gain extensive foundational skills to become an intermediate to advanced-level developer.

All resources are available at: https://github.com/PacktPublishing/Fundamentals-Of-Object-Oriented-Programming-Java-intelliJ
 <h2>What You Will Learn</h2>Learn basic Java syntax using variables and built-in operators Use and understand inheritance facilities in programming Use interfaces and demonstrate polymorphic behavior Create and implement collections and data structures Utilize exception-handling facilities and defensive programming Create solutions based on UML models
 <h2>Audience</h2>This course caters to beginner and novice programmers who like to develop a basic understanding of writing simple object-oriented programming in Java. Programming hobbyists and creative people who love learning and want to understand how software systems work, or anyone looking to advance their programming skillsets. The desired prerequisites for this course require you to have a basic understanding of Data Flow (DFD) and UML diagrams and have access to a personal computer and internet connection.
 <h2>Approach</h2>his course begins with an introduction to the paradigm and features of OOP using Java. The course delivers lessons with practical examples and live coding over high-quality video lessons with substantive explanations for lucidly understanding the content and concepts.
 <h2>Key Features</h2>Learn core programming, logical reasoning, critical reasoning, and problem-solving in Java code * Learn Java syntax to store, process, and retrieve data, input, and output with simple programs * Use built-in Java library I/O and create custom libraries and defensive programming techniques
 <h2>Github Repo</h2>https://github.com/PacktPublishing/Fundamentals-Of-Object-Oriented-Programming-Java-intelliJ
 <h2>About the Author</h2><h3>Doron Williams</h3>Doron William helps businesses and individuals streamline their systems and make them more efficient. He aligns business processes with appropriate solutions and improves existing ones. He believes in helping find ways to make people's lives easier by leveraging cutting-edge technology and developing, automating, and deploying more efficient and user-friendly software solutions.

He is a cloud and desktop-based solutions architect and software developer with experience in leading technical teams using Agile and DevOps methodologies to develop enterprise-level software solutions. He is also adept at analyzing the business to determine suitable strategies to install, maintain, and upgrade software and hardware infrastructure. He aims at helping businesses and individuals bridge the gap between humanity and technology.
 <h2>Course Outline</h2><h4>1. Module 1</h4>This section focuses on the introduction to the JAVA ecosystem. We learn to install, set up, and run our first JAVA program. We will also look at variables and operators in Java and work on projects based on what we learned in this section.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. IntroductionThis video introduces the author, the course in general, what to expect from the course, and a brief introduction to Java programming.</td></tr><tr><td style='padding: 15px;'>2. Module Objectives - Getting you comfortable with the JAVA ecosystemIn this video, we will look at the objectives of Module 1. We will define the Java development Lifecycle and compilation. We will differentiate between the different versions of Java and learn about basic Java syntax.</td></tr><tr><td style='padding: 15px;'>3. Environment Setup & First RunThis video illustrates how to install the Java development kit, configure it on our machine, and run the Java program for the first time.</td></tr><tr><td style='padding: 15px;'>4. Variables & Data TypesIn this lesson, we will learn about variables and look at the various datatypes available in Java. We will create a new Java project and understand the different data types.</td></tr><tr><td style='padding: 15px;'>5. Char Data TypeIn this video, we will understand the char datatype and briefly look at the string datatype. We will define several char variables in upper and lower case and numbers and integers.</td></tr><tr><td style='padding: 15px;'>6. Boolean & Logical OperatorsIn this lecture, we will learn about the Boolean datatype and also look at logical operators in Java. We will create statements and have our program evaluate whether the statements are true or false.</td></tr><tr><td style='padding: 15px;'>7. Program: User Input - Voting AgeWe will learn to accept user inputs, a critical step for any software program. We will learn to use the scanner library to achieve this.</td></tr><tr><td style='padding: 15px;'>8. Arithmetic OperatorsIn this lesson, we will perform basic arithmetic calculations used in Java for mathematical operations.</td></tr><tr><td style='padding: 15px;'>9. DateTimeWe will look at the Java built-in API that contains classes for representing data and time, the java.util, java.time, java.sql, and java.text packages.</td></tr><tr><td style='padding: 15px;'>10. Program: Date DifferenceIn this video, we will learn to write a simple program that uses the DateTime class to calculate the age difference between two siblings.</td></tr><tr><td style='padding: 15px;'>11. Program: Simple Interest CalculatorThis lecture will demonstrate how to write a program that calculates simple interest earned on a dollar amount invested at an interest rate.</td></tr><tr><td style='padding: 15px;'>12. Module SummaryThis video summarizes the concepts learned in Module 1: the Java development lifecycle and compilation process, understanding the different Java versions and development tools, and compiling and running programs via the command line.</td></tr></tbody></table> <h4>2. Module 2</h4>This section focuses on the core concepts of Java programming, including strings, string methods, StringBuilder, decision-making, loops, and arrays, and we will also learn to write simple programs.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. Module Objectives - Enabling our programs to make decisions based on inputThis brief video outlines what we will learn in this module, focusing mainly on the deeper elements of programming involving Java, like strings, arrays, loops, and decision-making.</td></tr><tr><td style='padding: 15px;'>2. StringsContinuing on our previous lesson, where we learned about the datatypes in Java, in this lesson, we will look at the string datatype in more detail.</td></tr><tr><td style='padding: 15px;'>3. String MethodsIn this video, we will learn about the two methods of assigning a string variable in Java programming.</td></tr><tr><td style='padding: 15px;'>4. StringbuilderHere, we will look at the StringBuilder, which creates a mutable or modifiable succession of characters in the strings class.</td></tr><tr><td style='padding: 15px;'>5. Type CastingIn this lesson, we will learn to use a feature called typecasting to change one datatype to another and look at the two methods of typecasting.</td></tr><tr><td style='padding: 15px;'>6. Flow Control: IF/ELSE, Ternary Operator - Test Scores ProgramWe will learn to use the IF statement to check if a block of conditions is true and the ELSE statement if false and write a program to evaluate test scores.</td></tr><tr><td style='padding: 15px;'>7. Flow Control: Switch Statement Program - Print Weekday Based On NumberLet's look at the SWITCH statement in this video, which is also a part of the decision-making tools in Java programming.</td></tr><tr><td style='padding: 15px;'>8. Flow Control: Loops - WHILE | DO-WHILE | FORHere, we will understand what a loop is, and we will look at how a loop executes a program as long as a specified condition is true.</td></tr><tr><td style='padding: 15px;'>9. Flow Control: Loops - BREAK | CONTINUEIn this lesson, we will continue on loops and closely examine the BREAK and CONTINUE keywords and their implementation.</td></tr><tr><td style='padding: 15px;'>10. ArraysIn this video, we will learn about Java arrays, which store multiple values in a single variable instead of creating separate variables for each value.</td></tr><tr><td style='padding: 15px;'>11. MethodsWe will understand a method, a block of code that runs only when called and passes data known as parameters into a method. This helps us reuse code.</td></tr><tr><td style='padding: 15px;'>12. Program: Calculate Test Score AverageIt is time to put all the knowledge we gained from the previous lessons into creating a program that tests the scoring average.</td></tr><tr><td style='padding: 15px;'>13. Program: Find Max Value In ArrayFurthering our program writing skills, we will learn to create a program that determines the maximum value in an array.</td></tr><tr><td style='padding: 15px;'>14. Module SummaryThis brief video succinctly summarizes what we learned throughout this module.</td></tr></tbody></table> <h4>3. Module 3</h4>Module 3 focuses on classes and objects, how to create them, and understanding the difference between abstract classes and interfaces. We will examine file input and outputs and exception handling in defensive programming.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. Module Objectives - Understanding OOP Architecture and Design conceptsThis brief video outlines the concepts we will learn in this module, including OOP architecture and design.</td></tr><tr><td style='padding: 15px;'>2. Classes & ObjectsHere, we will understand what classes and objects are and which are the keys to object-oriented programming.</td></tr><tr><td style='padding: 15px;'>3. Constructors & Access Specifiers (Setters and Getters)In this lesson, we will learn about constructors, a block of code that initializes a newly created object, and access specifiers that determine if other classes can use a particular method.</td></tr><tr><td style='padding: 15px;'>4. The 4 Pillars Of OOPThis video illustrates the four major pillars of object-oriented programming: encapsulation, abstraction, polymorphism, and inheritance.</td></tr><tr><td style='padding: 15px;'>5. InheritanceIn this video, we will look at inheritance in Java, where we have a superclass and a derived class, which inherits the attributes from the parent class.</td></tr><tr><td style='padding: 15px;'>6. Multi-level Inheritance, PolymorphismHere, we will look at the multilevel inheritance of the classes and how we can share the attributes of many subclasses.</td></tr><tr><td style='padding: 15px;'>7. Abstract ClassThis lesson will teach us how to create a class to represent concepts rather than objects.</td></tr><tr><td style='padding: 15px;'>8. InterfacesThis video elaborates on interfaces, how an interface determines the software's features, and how they can be implemented.</td></tr><tr><td style='padding: 15px;'>9. Const, Enum, Static, FinalIn this lecture, we will learn about constants and static variables and how to create variables using the final and static methods.</td></tr><tr><td style='padding: 15px;'>10. CollectionsLet's understand about Java collections framework designed to support numerous collections hierarchically.</td></tr><tr><td style='padding: 15px;'>11. Exception HandlingHere, we will look at exceptions or conditions that may arise during the execution of a Java program and understand the error or exception handling codes.</td></tr><tr><td style='padding: 15px;'>12. File HandlingIn this video, we will be looking at file and exception handling. We will wrap our file statements inside the try and catch blocks.</td></tr><tr><td style='padding: 15px;'>13. Program: Custom Message Based on WeekdayWe will use all the concepts learned in this module and write a program that creates a custom message based on the day of the week.</td></tr><tr><td style='padding: 15px;'>14. Module SummaryThis video briefly outlines the concepts learned in the module in a quick refresher.</td></tr></tbody></table> <h4>4. Module 4</h4>In module four, we will look at sample real-world programs, use a UML diagram, and understand version control and GitHub integration.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. Module Objectives - Designing real-world solutions based on UML diagramsIn this video, we will briefly look at an outline of the objectives of this module to include UML cases and create sample programs to understand the concepts further.</td></tr><tr><td style='padding: 15px;'>2. Project: Payroll System Simulation - Part 1This lesson will teach us to create a simple payroll management system. In this lesson, we will look at the program's basic structure.</td></tr><tr><td style='padding: 15px;'>3. Project: Payroll System Simulation - Part 2We will continue with the second part of the payroll system and look at how to create changes or updates to the classes used.</td></tr><tr><td style='padding: 15px;'>4. Project: Payroll System Simulation - Part 3In part 3 of the payroll system, we will look at using the paystub method for our employee classes created in the system.</td></tr><tr><td style='padding: 15px;'>5. Project: Payroll System Simulation - Part 4In this video, we will be introduced to GitHub, where we will store our code for the payroll management system.</td></tr><tr><td style='padding: 15px;'>6. Project: Payroll System Simulation - Part 5In the final lesson on the payroll system, we will focus on grouping our employees' class based on the department they work in and make changes to our classes to display the results.</td></tr><tr><td style='padding: 15px;'>7. Project: ATM Simulation Part 1 - Interface ExampleThis video demonstrates how to simulate a real-world ATM program using a UML example.</td></tr><tr><td style='padding: 15px;'>8. Project: ATM Simulation Part 2 - UI MenuIn the last video, we created a base account class and implemented the transactions interface. Here, we will learn to create user prompts to input data into the system.</td></tr><tr><td style='padding: 15px;'>9. Project: ATM Simulation Part 3 - Single InheritanceThis video focuses on rectifying the code using the break statement that will handle the unwanted comments appearing in the ATM system,</td></tr><tr><td style='padding: 15px;'>10. Project: ATM Simulation Part 4 - Transactions ReportWe will continue further in the ATM project and implement the transaction portion of the ATM program.</td></tr><tr><td style='padding: 15px;'>11. Project: ATM Simulation Part 5 - GitHub IntegrationWe will check and execute our ATM simulation program and learn to upload the program on GitHub.</td></tr><tr><td style='padding: 15px;'>12. Module Summary</td></tr></tbody></table>

Java

This course introduces you to the paradigm and features of object-oriented programming using Java, an object-oriented language popular in the industry and IntelliJ. The course entails modeling objects and classes, object-oriented facilities like inheritance and polymorphism, native data structures, exception handling, file management, and streams.

Fundamentals Of Object-Oriented Programming: Java and IntelliJ

Harpenden

The market for professional services is becoming increasingly competitive, with some firms and individuals becoming very effective at winning new work, leaving others lagging way behind.Given the choice between spending time on client work and business development work, we all tend to choose that which we feel to be easier, more attractive and more aligned with our image of ourselves. We stay within our comfort zones, we focus on client work, and we only resort to business development work when we have to, which can also lead to 'feast or famine' syndrome.The programme will help participants:<ul><li>Understand the professional business development approach and the style that is appropriate for their business and their clients</li><li>Follow a process to guide their conversations and business development meetings</li><li>Prepare thoroughly for a business development meeting/contact with a client to ensure they use their time efficiently and maximise results</li><li>Create a great first impression and professional opening to a conversation</li><li>Ask open questions and listen effectively in order to spot opportunities, understand needs and progress the opportunity</li><li>Identify and understand buying and decision-making processes and criteria</li><li>Skilfully and confidently handle questions and objections</li><li>Sell the benefits of their services and approach over those of their competitors</li><li>Progress the sale by agreeing next steps and gaining commitment appropriately</li></ul><section>
 <h3>1 Introduction</h3><ul><li>Aims and objectives of the programme</li><li>Personal introductions and objectives</li><li>Workshop overview</li></ul> <h3>2 An introduction to business development and selling for professionals</h3><ul><li>What is selling?</li><li>Who are you selling to?</li><li>The buying experience</li><li>What clients want</li><li>The four-step business development process</li><li>The business development cycle and pipeline management</li><li>Upselling and cross-selling as well as winning new clients</li></ul> <h3>3 Networking and generating leads</h3><ul><li>What is networking?</li><li>Networking objectives</li><li>It's not what you know but who you know</li><li>Asking for referrals and introductions</li><li>Making appointments from networking activity</li></ul> <h3>4 Opening the sales relationship/sales meeting</h3><ul><li>What potential customers are thinking</li><li>Judging first impressions</li><li>Creating positive first impressions</li><li>Building rapport and creating interest and impact</li><li>Earning the right</li></ul> <h3>5 Core communication skills for professional selling</h3><ul><li>Overcoming barriers to listening</li><li>The art of listening</li><li>Questioning refresher</li><li>Types of questions</li><li>Questioning funnel</li></ul> <h3>6 Understanding and identifying needs and opportunities</h3><ul><li>Identifying the questions to ask to identify needs and opportunities</li><li>Questions to move us through the buying and selling process</li><li>Understanding their buying processes</li><li>Asking questions that position you as a 'trusted adviser'</li><li>The questions that give you a competitive advantage</li><li>Knowing when you have asked enough questions</li></ul> <h3>7 Introducing solutions</h3><ul><li>Tailoring your 'pitch' to the client</li><li>Speaking the client's language</li><li>Using features and benefits</li><li>Applying the benefit cycle</li></ul> <h3>8 Handling objections and concerns</h3><ul><li>Identifying the typical objections and concerns</li><li>Understanding why clients raise objections and concerns</li><li>Following a structure for handling objections</li><li>Handling the price objection</li></ul> <h3>9 Gaining commitment</h3><ul><li>Knowing when to close</li><li>The art of checking</li><li>Recognising buying signals</li><li>Small c and big C</li></ul> <h3>10 Putting it all together</h3><ul><li>Personal learning summary and action plans</li></ul> 


 </section>

The In House Training Company

Coaching & Consulting Business

Professional Selling Skills (PSS)

Counselling Skills

Business Development

Business Case Development

Business Development Manager

Business development for professional services (In-House)

Mental Health First Aid Refresher 4-hour training sessionsCan you remember ALGEE?&nbsp;Mental Health Action Plan.Empower Mental Health First Aiders and Champions to maintain their skills with regular Refresher training. Just like physical first aid, we recommend that you refresh your skills every two to three years. (Certificate expires after 3 years). &nbsp;If it&#39;s time to update your skills, book onto an MHFA Refresher course now and feel confident that you are performing your vital role safely.Revisit the key areas from the full course. Keep up to date with the latest statistics and information.If you are a Mental Health First Aider or MHFA Champion you have skills for life that support you and the people around you. &nbsp;Mental Health First Aid training can be kept up to date through this four hour MHFA Refresher course, which will empower you to: &nbsp;Update your knowledge of mental health and what influences it Update your awareness of current mental health supports available Practise applying the Mental Health First Aid Action Plan. Learning takes place through a mix of presentations, group discussions and workshop activities. We limit numbers to 20 people per course so that the instructor can keep people safe and supported, to get the most from their learning experience with us.This course is for those that have completed the MHFA England Mental Health First Aid or Champion course.&nbsp;<a href="https://www.mindmapswellbeing.com/faq-s/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">FAQs</a>

Mental Health First Aid Refresher 4-hour training sessions
Can you remember ALGEE? Mental Health Action Plan.
Empower Mental Health First Aiders and Champions to maintain their skills with regular Refresher training. Just like physical first aid, we recommend that you refresh your skills every two to three years. (Certificate expires after 3 years). If it's time to update your skills, book onto an MHFA Refresher course now and feel confident that you are performing your vital role safely.
Revisit the key areas from the full course. Keep up to date with the latest statistics and information.
If you are a Mental Health First Aider or MHFA Champion you have skills for life that support you and the people around you. Mental Health First Aid training can be kept up to date through this four hour MHFA Refresher course, which will empower you to: Update your knowledge of mental health and what influences it Update your awareness of current mental health supports available Practise applying the Mental Health First Aid Action Plan. Learning takes place through a mix of presentations, group discussions and workshop activities. We limit numbers to 20 people per course so that the instructor can keep people safe and supported, to get the most from their learning experience with us.
This course is for those that have completed the MHFA England Mental Health First Aid or Champion course. 
FAQs

Mindmaps Wellbeing

Mental Health Awareness

Mental Health First Aid

Approved Training Organisation (ATO)

Health & Wellbeing

Occupational Health & Wellbeing

Mental Health

Accredited Mental Health First Aid

Wellbeing

Mental Health At Work

Mental Health Nurse

Empower Mental Health First Aiders and Champions to maintain their skills with regular Refresher training. Just like physical first aid, we recommend that you refresh your skills every two to three years. (Certificate expires after 3 years).  If it's time to update your skills, book onto an MHFA Refresher course now and feel confident that you are performing your vital role safely.

MHFA England Refresher 

Active Lancashire

MECC 90mins Online Familiarisation / Refresher 

The Designated Safeguarding Lead Advanced Course is an expert-led update and refresher course for school and college DSLs and their Deputies. It is an extensive, authoritative and highly rated, full-day training course that ensures DSL/DDSLs have the most comprehensive, effective and up-to-date knowledge and strategies in place to lead the safeguarding provision in their setting.All too often DSLs and Deputy DSLs come to us fed up with the dull &#39;death by powerpoint&#39; statutory training they have attended through their LA, or the &#39;watch, click and multiple-choice&#39; DSL refresher course that they have attended through an online course provider in order to meet their statutory training requirements... this course is nothing like those! <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;">View all testimonials</a>

The Designated Safeguarding Lead Advanced Course is an expert-led update and refresher course for school and college DSLs and their Deputies. It is an extensive, authoritative and highly rated, full-day training course that ensures DSL/DDSLs have the most comprehensive, effective and up-to-date knowledge and strategies in place to lead the safeguarding provision in their setting.
All too often DSLs and Deputy DSLs come to us fed up with the dull 'death by powerpoint' statutory training they have attended through their LA, or the 'watch, click and multiple-choice' DSL refresher course that they have attended through an online course provider in order to meet their statutory training requirements... this course is nothing like those!

View all testimonials

Brightcore Consultancy

Designated safeguarding lead (DSL)

The Designated Safeguarding Lead Advanced Course is an expert-led update and refresher course for school and college DSLs and their Deputies. It is an extensive, authoritative and highly rated, full-day training course that ensures DSL/DDSLs have the most comprehensive, effective and up-to-date knowledge and strategies in place to lead the safeguarding provision in their setting.

Designated Safeguarding Lead Refresher Training

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

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

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

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





DG Legal

Compliance Officer For Finance and Administration (COFA) Masterclass Course

General Delegate

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

Retainer Delegate

PLEASE NOTE - This course is Day 1 of a 2 day process - All new DSLs/DDSLs should also attend the first day of Training (New to DSL DAY 1) to complete their training. The New to the Role of Designated Safeguarding Lead Course is an expert-led course for those new to the role of school / college DSLs and or Deputy DSL. It is an extensive, authoritative and highly rated, full-day training course that ensures DSLs &amp; DDSLs have the most comprehensive, effective and up-to-date understanding of and knowledge of how to lead the safeguarding provision in their setting.All too often DSLs and Deputy DSLs come to us fed up with the dull &#39;death by powerpoint&#39; statutory training they have attended through their LA, or the &#39;watch, click and multiple-choice&#39; DSL refresher course that they have attended through an online course provider in order to meet their statutory training requirements... this course is nothing like those!<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;">View all testimonials </a>

PLEASE NOTE - This course is Day 1 of a 2 day process - All new DSLs/DDSLs should also attend the first day of Training (New to DSL DAY 1) to complete their training. 
The New to the Role of Designated Safeguarding Lead Course is an expert-led course for those new to the role of school / college DSLs and or Deputy DSL. It is an extensive, authoritative and highly rated, full-day training course that ensures DSLs & DDSLs have the most comprehensive, effective and up-to-date understanding of and knowledge of how to lead the safeguarding provision in their setting.
All too often DSLs and Deputy DSLs come to us fed up with the dull 'death by powerpoint' statutory training they have attended through their LA, or the 'watch, click and multiple-choice' DSL refresher course that they have attended through an online course provider in order to meet their statutory training requirements... this course is nothing like those!
View all testimonials

The New to the Role of Designated Safeguarding Lead Course is an expert-led course for those new to the role of school / college DSLs and or Deputy DSL.

New to the role DSL Training - DAY 2

This CPD accredited HACCP Refresher &amp; Update course is for those who already hold a Level 3 or Level 4 HACCP qualification and are looking to refresh their knowledge of the subject. This course will also include updates to the subject so that attendees can feel confident that they are aware of changes and industry thinking and challenges relating to HACCP.Holders of the qualification will have the knowledge necessary to be an integral part of a food business as well as part of Technical &amp; Quality departments and HACCP team members, team leaders, consultants or trainers. The qualification is also suitable for those working in related industries, such as packaging, storage &amp; distribution.The qualification is also relevant to those owning/managing smaller food businesses to refresh underpinning knowledge to develop and maintain a &nbsp;Food Safety Management System.HACCP training is regarded by the Foods Standards Agency &amp; Codex Alimentarius International Food Standards as being essential to maintain good practice in the production of safe food.This course has been accredited by the CPD Accreditation Office for delivery, structure and content.

This CPD accredited HACCP Refresher & Update course is for those who already hold a Level 3 or Level 4 HACCP qualification and are looking to refresh their knowledge of the subject. This course will also include updates to the subject so that attendees can feel confident that they are aware of changes and industry thinking and challenges relating to HACCP.
Holders of the qualification will have the knowledge necessary to be an integral part of a food business as well as part of Technical & Quality departments and HACCP team members, team leaders, consultants or trainers. The qualification is also suitable for those working in related industries, such as packaging, storage & distribution.
The qualification is also relevant to those owning/managing smaller food businesses to refresh underpinning knowledge to develop and maintain a Food Safety Management System.
HACCP training is regarded by the Foods Standards Agency & Codex Alimentarius International Food Standards as being essential to maintain good practice in the production of safe food.
This course has been accredited by the CPD Accreditation Office for delivery, structure and content.

Ask Sonia Limited

Food Safety

HACCP

CPD accredited HACCP Refresher & Update course. 
Delivered online (Zoom) by a live tutor.
Exam and Certificate fee included in the price.

CPD Accredited HACCP & Refresher & Update (1 day)

Grantham

CILT PCV Transport Manager Refresher / OLAT 2 Day Course Online
Our OLAT & Transport Manager Courses are CILT (Chartered Institute of Logistics and Transport) accredited and so they are one of the courses recommended by the Traffic Commissioner, and they are also FORS Approved Manager Training.
If you are in contact with the Traffic Commissioner for any reason, especially if you have applied to be transport manager for an organisation, you are strongly advised to attend a 2-day course, which is often recommended by the Traffic Commissioner as the most appropriate.
This course will cover the following areas:
•Background to the Operator’s Licence
•Compliance enforcement
•Working time & driver’s hours
•Vehicle roadworthiness and defect reporting
•Construction and use requirements
•Driver licences/driver CPC
•Speed limits
•Environmental considerations
On completion of this course, you will be able to:
•Recount the requirement to obtain and maintain an operator licence.
•Demonstrate how and why driver hours legislation are crucial to safety and compliance to the undertaking.
•State the responsibilities of management and drivers have regarding vehicle roadworthiness and defect reporting.
•Identify the requirements of driver licence/DQC checks.
•Demonstrate an awareness of sector legislative awareness, safe fleet operation and environmental requirements.
Our courses offer both in-person and online learning options.
Completion of the remote learning course will gain you the same accreditation as completion of the face-to-face training course.
Secure your spot today by booking your ticket through Cademy or contacting us at 0345 9001312 and complete the online booking form. These details will be used to produce a registration document and provide you with a course certificate on successful completion of the course. Once registered, your booking will be complete, and a member of the team will contact you.
Login details will be given 48 hours prior to the course starting.
This is a two-day course, the start time is 8am each day.
Course cost includes 2-day training £411 (£280 course fee, CILT certification fee £75) plus VAT. 

Total Compliance 

Driving & Vehicles

Compliance & Safety

CILT PCV Transport Manager Refresher / OLAT 2 Day Course Online & In-person

CILT HGV Transport Manager Refresher / OLAT 2 Day Course Online
Our OLAT & Transport Manager Courses are CILT (Chartered Institute of Logistics and Transport) accredited and so they are one of the courses recommended by the Traffic Commissioner, and they are also FORS Approved Manager Training.
If you are in contact with the Traffic Commissioner for any reason, especially if you have applied to be transport manager for an organisation, you are strongly advised to attend a 2-day course, which is often recommended by the Traffic Commissioner as the most appropriate.
This course will cover the following areas:
•Background to the Operator’s Licence
•Compliance enforcement
•Working time & driver’s hours
•Vehicle roadworthiness and defect reporting
•Construction and use requirements
•Driver licences/driver CPC
•Speed limits
•Environmental considerations
On completion of this course, you will be able to:
•Recount the requirement to obtain and maintain an operator licence.
•Demonstrate how and why driver hours legislation are crucial to safety and compliance to the undertaking.
•State the responsibilities of management and drivers have regarding vehicle roadworthiness and defect reporting.
•Identify the requirements of driver licence/DQC checks.
•Demonstrate an awareness of sector legislative awareness, safe fleet operation and environmental requirements.
Our online courses work in the same way that our classroom courses do, but they are completed via the online platform called Zoom. The course can be completed on any device that the Zoom app can be used on, such as a PC, laptop, tablet or smart phone.
Completion of the remote learning course will gain you the same accreditation as completion of the face-to-face training course.
Secure your spot today by booking your ticket through Cademy or contacting us at 0345 9001312 and complete the online booking form. These details will be used to produce a registration document and provide you with a course certificate on successful completion of the course. Once registered, your booking will be complete, and a member of the team will contact you.
Login details will be given 48 hours prior to the course starting.
This is a two-day course, the start time is 8am each day.
Course cost includes 2-day training £411 (£280 course fee, CILT certification fee £75) plus VAT. 

CILT HGV Transport Manager Refresher / OLAT 2 Day Course Online & In-person

<div id="course-pills-1">Duration1 Days6 CPD hoursWriting is a key method of communication for most people, and it?s one that many people struggle with. This workshop will give participants a refresher on basic writing concepts (such as spelling, grammar, and punctuation), and an overview of the most common business documents (such as proposals, reports, and agendas), giving you that extra edge in the workplace.</div><div id="course-pills-2"><h3>1 - Getting Started</h3> <ul> <li>Workshop Objectives</li> <li>Pre-Assignment Review</li> </ul> <h3>2 - Working with Words</h3> <ul> <li>Spelling</li> <li>Grammar</li> <li>Creating a Cheat Sheet</li> </ul> <h3>3 - Constructing Sentences</h3> <ul> <li>Parts of a Sentence</li> <li>Punctuation</li> <li>Types of Sentences</li> </ul> <h3>4 - Creating Paragraphs</h3> <ul> <li>The Basic Parts</li> <li>Organization Methods</li> </ul> <h3>5 - Writing Meeting Agendas</h3> <ul> <li>The Basic Structure</li> <li>Choosing a Format</li> <li>Writing the Agenda</li> </ul> <h3>6 - Writing E-mails</h3> <ul> <li>Addressing Your Message</li> <li>Grammar and Acronyms</li> </ul> <h3>7 - Writing Business Letters</h3> <ul> <li>The Basic Structure</li> <li>Choosing a Format</li> <li>Writing the Letter</li> </ul> <h3>8 - Writing Proposals</h3> <ul> <li>The Basic Structure</li> <li>Choosing a Format</li> <li>Writing the Proposal</li> </ul> <h3>9 - Writing Reports</h3> <ul> <li>The Basic Structure</li> <li>Choosing a Format</li> <li>Writing the Report</li> </ul> <h3>10 - Other Types of Documents</h3> <ul> <li>Requests for Proposals</li> <li>Projections</li> <li>Executive Summaries</li> <li>Business Cases</li> </ul> <h3>11 - Proofreading and Finishing</h3> <ul> <li>A Proofreading Primer</li> <li>How Peer Review Can Help</li> <li>Printing and Publishing</li> </ul> <h3>12 - Wrapping Up</h3> <ul> <li>Words from the Wise</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans Business Writing 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 Business Writing 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>

Content Writing

Writing Skills

Book Writing

Trainers Course

Business English

Business Writing

A real estate financial model is the abstract representation of an investment scenario. Building a Real Estate Financial Model requires theory, maths and excel.This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector. The training aims to give delegates a grasp of MS Excel and its usage in real estate cash flow modelling. You will be able to set up a financial modelling cash flow from a blank spreadsheet by using the most common shortcuts, formulas and functions. We will also cover the use of pivot tables to clean and organise your data.This is an excellent starter/refresher course, whether you&rsquo;re a recent graduate or a mid/senior professional. On this course, you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn spreadsheet modelling best practice</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Look over excel tips for general day to day use in MS Excel</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Recognise spreadsheet navigation and presentation tricks</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand financial mathematics &amp; conventional valuations</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Identify real estate cash flow model single-let common functions and formulas</li></ul> Who will benefit from this course?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Graduate Real Estate professionals</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">APC candidates</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Mid-Senior professionals looking for a refresher on core model building skills and best practice</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Any professionals looking to learn how to build a real estate focused model from scratch.</li></ul> Day One: Conventional Valuations<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Layer Method</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Over Rented</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield</li></ul> Real Estate Cash Flow Models (Single-Let)<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Annual Discounted Cash Flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">&ldquo;What If&rdquo;&nbsp;Analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Quarterly Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flows with Rent Review</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Multiple Rent Reviews</li><li value="6" fr-original-style="" style="box-sizing: border-box;">NPV, IRR, Equity Multiple, Cash on Cash</li></ul> Additional topics:<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">IF, SUMIF &amp; Switches&rsquo;</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Sensitivity Analysis: Data Table &amp; Changing Calculation Options</li></ul> Other Excel tips and tricks, including navigation and presentation:<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Functions and formulas included: General formatting, data entry, manipulation and creating formulas, Copy/Paste and general navigation with shortcuts, Solver (used to calculate equivalent yield), Scenarios, Customise spreadsheet, Navigation Shortcuts, SUM, TODAY, PV, IRR, EDATE, EOMONTH, DAY, MONTH, YEAR, NPV, YEARFRAC</li></ul><div fr-original-style="" style="box-sizing: border-box;"> </div>Included in the Course<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">A Bayfield Training Certification &amp; 7.5 CPD Hours</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Course Files</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul> For more information about the An Introduction to Real Estate in Excel such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



A real estate financial model is the abstract representation of an investment scenario. Building a Real Estate Financial Model requires theory, maths and excel.
This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector. The training aims to give delegates a grasp of MS Excel and its usage in real estate cash flow modelling. You will be able to set up a financial modelling cash flow from a blank spreadsheet by using the most common shortcuts, formulas and functions. We will also cover the use of pivot tables to clean and organise your data.
This is an excellent starter/refresher course, whether you’re a recent graduate or a mid/senior professional.


On this course, you will…
Learn spreadsheet modelling best practice
Look over excel tips for general day to day use in MS Excel
Recognise spreadsheet navigation and presentation tricks
Understand financial mathematics & conventional valuations
Identify real estate cash flow model single-let common functions and formulas


Who will benefit from this course?
Graduate Real Estate professionals
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
APC candidates
Mid-Senior professionals looking for a refresher on core model building skills and best practice
Any professionals looking to learn how to build a real estate focused model from scratch.


Day One:


Conventional Valuations
Term & Reversion
Layer Method
Over Rented
Equivalent Yield


Real Estate Cash Flow Models (Single-Let)
Annual Discounted Cash Flows
“What If” Analysis
Quarterly Discounted Cash Flow
Cash Flows with Rent Review
Multiple Rent Reviews
NPV, IRR, Equity Multiple, Cash on Cash


Additional topics:
IF, SUMIF & Switches’
Sensitivity Analysis: Data Table & Changing Calculation Options


Other Excel tips and tricks, including navigation and presentation:
Functions and formulas included: General formatting, data entry, manipulation and creating formulas, Copy/Paste and general navigation with shortcuts, Solver (used to calculate equivalent yield), Scenarios, Customise spreadsheet, Navigation Shortcuts, SUM, TODAY, PV, IRR, EDATE, EOMONTH, DAY, MONTH, YEAR, NPV, YEARFRAC
Included in the Course
A Bayfield Training Certification & 7.5 CPD Hours
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Financial Analysis

Financial Management

Financial Risk Management

Professional Development

Continuous Professional Development (CPD)

This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector.

520 Courses

Data Wrangling with Python

By Nexus Human

Influencing with Behavioural Styles

By Ei4Change

Diploma in Web Design (HTML5 CSS3 and Bootstrap)

By John Academy

Data Science & Machine Learning with Python Course

By NextGen Learning

Cypress - Modern Automation Testing from Scratch + Framework

By Packt

Data Analyst : Data Analyst (Data Analytics) - Level 5 Diploma Course

By One Education

The Complete Python Course including the Django Web Framework

By Packt

The Complete Web Design Course

By John Academy

Fundamentals Of Object-Oriented Programming: Java and IntelliJ

By Packt

Business development for professional services (In-House)

By The In House Training Company

Search By Location