<p><strong>Data analysis</strong> 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 <strong>7.9% in this year</strong>, creating numerous job opportunities in fields such as data analysis.</p><p>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.</p><p>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!</p><p><strong>Dis Diploma Included Courses are: </strong></p><ul><li><strong>Course 01: Diploma in Data Analytics with Tableau<br /></strong></li><li><strong>Course 02: Data Analytics<br /></strong></li><li><strong>Course 03: Google Data Studio: Data Analytics</strong><strong><br /></strong></li><li><strong>Course 04: Big Data Analytics with PySpark Tableau Desktop and MongoDB<br /></strong></li><li><strong>Course 05: Learn MySQL from Scratch for Data Science and Analytics</strong><strong><br /></strong></li><li><strong>Course 06: Data Analysis In Excel<br /></strong></li><li><strong>Course 07: Diploma in Data Analysis Fundamentals<br /></strong></li><li><strong>Course 08: Business Data Analysis<br /></strong></li><li><strong>Course 09: Data Science &amp; Machine Learning with Python<br /></strong></li><li><strong>Course 10: R Programming for Data Science<br /></strong></li><li><strong>Course 11: Learn Python, JavaScript, and Microsoft SQL for Data science</strong></li></ul><p><strong>Key Learnings:</strong></p><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><p><strong>Course Significant Points:</strong></p><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><p><strong>How is the course assessed?</strong></p><p>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.</p><p><strong>Meet the Endorsement</strong></p><p>The 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.</p><p><strong>How will QLS boost your worth?</strong></p><ul><li>Achieving <strong>Quality Licence Scheme</strong> endorsed certificates can provide you with valued and credible evidence of <strong>your skills and knowledge to potential employers. </strong></li><li>Quality Licence Scheme (QLS) endorsements are awarded to training programmes and courses that <strong>meet high quality standards</strong>, ensuring that your certificate represents <strong>a valuable achievement.</strong></li><li>The stringent assessment process involved in achieving Quality Licence Scheme Endorsed Certificates ensures that you have acquired the <strong>necessary skills and knowledge to excel in your chosen field.</strong></li></ul><p><strong>Meet the Accreditation</strong></p><p>CPD Quality Standards (CPD QS) accreditation assures the Data Analysis with Excel course training and learning activities are relevant, reliable, and up to date.</p><p><strong>How Will CPD Accredited Value You?</strong></p><ul><li>CPD accreditation ensures that the training programme or course you have completed has been <strong>independently reviewed</strong> and meets <strong>rigorous quality standards.</strong></li><li>By achieving CPD accredited certificates, you can <strong>enhance your career prospects</strong>, build your <strong>professional reputation</strong>, and stay competitive in <strong>today's job market.</strong></li></ul><p><strong>**Diploma in Data Analytics with Tableau**</strong></p><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><p><strong>**Data Analytics**</strong></p><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><p><strong>**Google Data Studio: Data Analytics**</strong></p><ul><li>Introduction</li><li>Google Sheets</li><li>Google Data Studio</li></ul><p><strong>**Big Data Analytics with PySpark Tableau Desktop and MongoDB**</strong></p><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><p><strong>**Learn MySQL from Scratch for Data Science and Analytics**</strong></p><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><p><strong>**Data Analysis In Excel**</strong></p><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><p><strong>**Diploma in Data Analysis Fundamentals**</strong></p><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><p><strong>**Business Data Analysis**</strong></p><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><p><strong>**Data Science &amp; Machine Learning with Python**</strong></p><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<br /><ul><li>Re-Scaling Data</li><li>Standardizing Data</li><li>Normalizing Data</li><li>Binarizing Data</li></ul></li><li>Feature Selection - Introduction<br /><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<br /><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<br /><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<br /><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<br /><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<br /><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><p><strong>**R Programming for Data Science**</strong></p><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><p><strong>**Learn Python, JavaScript, and Microsoft SQL for Data science**</strong></p><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">
                            <p><strong>Data Analysis course is ideal for: </strong></p><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">
                            <p>There are no specific prerequisites to enrol in Data analysis course. <strong> Anyone and everyone</strong> can take this course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>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:</p><ul><li><strong>Data Analyst </strong>(Average annual salary £35,000)</li><li><strong>Research Analyst</strong> (Average annual salary £28,552)</li><li><strong>Business Analyst</strong> (Average annual salary £42,618)</li><li><strong>Risk Analyst </strong>(Average annual salary £41,340)</li><li><strong>Financial Analyst</strong> (Average annual salary £50,300)</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

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

                        </div>

One Education

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

General Admission

Packt

Web Development

Python

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><strong>Description:</strong></h3>
<p><span>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.</span></p>
<p><span>Master the advanced techniques of HTML 5, CSS 3, and Bootstrap for designing attractive and professional web pages by enrolling in the </span><b>The Complete Web Design Course </b><span>course.</span></p>
<p><span>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.</span></p>
<p><span>Upon completion, you will be able to design any types of websites using HTML 5, CSS 3, and Bootstrap.</span></p>
<h3><strong>Who is the course for?</strong></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><strong>Entry Requirement:</strong></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><strong>Assessment:</strong></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><strong>Certification:</strong></h3>
<p>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.</p>
<h3><strong>Why choose us?</strong></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><strong>Career Path:</strong></h3>
<p><span>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.</span></p>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Welcome</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>1.1 Intro</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>1.2 Install the Tools and Get Started</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">HTML 5</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>2.1 Intro to HTML</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>2.2 What is HTML</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>2.3 Start a New HTML File &amp; Use Tags</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>2.4 Header Tags</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>2.5 Edit Text</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>2.6 Links</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>2.7 Images</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>2.8 Lists</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>2.9 Challenge 1</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>2.10 HTML Outro</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">CSS 3</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.1 CSS Intro</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.2 Add CSS Styles</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.3 Classes and IDs</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.4 Borders</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.5 Sizing</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.6 Padding and Margin</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.7 Text Styles</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.8 DIVs</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.9 Postioning</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.10 Hover</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.11 Easily Center Elements</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.12 Fonts</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.13 Challenge</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>3.14 CSS Outro</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Bootstrap</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>4.1 Intro to Bootstrap</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>4.2 Install Bootstrap</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>4.3 Indenting and Containers</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>4.4 The Grid System</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>4.5 Images</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>4.6 Buttons</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>4.7 Challenge 3</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>4.8 Bootstrap Outro</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Project 1 - Design a Landing Page</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>5.1 Landing Page Intro</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>5.2 Sketch Your Landing Page</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>5.3 The Top Section</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>5.4 Polish the Top Section</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>5.5 Adding Images</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>5.6 The Main Points Section</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>5.7 Collecting Emails With an Opt-In Form</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>5.8 Challenge 4</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>5.9 Landing Page Outro</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Project 2 - Business Website</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>6.1 Business Site Intro</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>6.2 Sketch Up</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>6.3 Using Fancy Font Logo</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>6.4 Carousel Basics</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>6.5 Carousel Extras</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>6.6 Text on Images</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>6.7 Phone Number Icon</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>6.8 Google Maps</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>6.9 Font Awesome</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>6.10 Challenge 4</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>6.11 Business Site Outro</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Project 3 - Portfolio</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>7.1 Intro</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>7.2 Portfolio Sketch</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>7.3 Jumbotron</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>7.4 Nav Bar</td>
					<td> </td>
					<td><span><i></i> 00:24:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>7.5 Panels</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>7.6 Challenge 5</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>7.7 Portfolio Outre</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Hosting - Getting Your Website on the Internet</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>8.1 Hosting</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>8.2 Bluehost</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>8.3 Uploading</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>8.4 Tips</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>8.5 Hosting Outro</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

John Academy

Online Course Marketing

Online Course Creation

HTML & CSS

Web Designer

Website Design

Web Design

The Complete Web Design Course

<strong>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.</strong>
        <p>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</p>
        <h2>What You Will Learn</h2><p>Learn basic Java syntax using variables and built-in operators<br>Use and understand inheritance facilities in programming<br>Use interfaces and demonstrate polymorphic behavior<br>Create and implement collections and data structures<br>Utilize exception-handling facilities and defensive programming<br>Create solutions based on UML models</p>
        <h2>Audience</h2><p>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.</p>
        <h2>Approach</h2><p>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.</p>
        <h2>Key Features</h2><p>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</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Fundamentals-Of-Object-Oriented-Programming-Java-intelliJ</p>
        <h2>About the Author</h2><h3>Doron Williams</h3><p>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.</p>
        <h2>Course Outline</h2><h4>1. Module 1</h4><p>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.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video introduces the author, the course in general, what to expect from the course, and a brief introduction to Java programming.</p></td></tr><tr><td style='padding: 15px;'><p>2. Module Objectives - Getting you comfortable with the JAVA ecosystem</p><p style='margin: 0'>In 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.</p></td></tr><tr><td style='padding: 15px;'><p>3. Environment Setup & First Run</p><p style='margin: 0'>This video illustrates how to install the Java development kit, configure it on our machine, and run the Java program for the first time.</p></td></tr><tr><td style='padding: 15px;'><p>4. Variables & Data Types</p><p style='margin: 0'>In 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.</p></td></tr><tr><td style='padding: 15px;'><p>5. Char Data Type</p><p style='margin: 0'>In 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.</p></td></tr><tr><td style='padding: 15px;'><p>6. Boolean & Logical Operators</p><p style='margin: 0'>In 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.</p></td></tr><tr><td style='padding: 15px;'><p>7. Program: User Input - Voting Age</p><p style='margin: 0'>We will learn to accept user inputs, a critical step for any software program. We will learn to use the scanner library to achieve this.</p></td></tr><tr><td style='padding: 15px;'><p>8. Arithmetic Operators</p><p style='margin: 0'>In this lesson, we will perform basic arithmetic calculations used in Java for mathematical operations.</p></td></tr><tr><td style='padding: 15px;'><p>9. DateTime</p><p style='margin: 0'>We 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.</p></td></tr><tr><td style='padding: 15px;'><p>10. Program: Date Difference</p><p style='margin: 0'>In this video, we will learn to write a simple program that uses the DateTime class to calculate the age difference between two siblings.</p></td></tr><tr><td style='padding: 15px;'><p>11. Program: Simple Interest Calculator</p><p style='margin: 0'>This lecture will demonstrate how to write a program that calculates simple interest earned on a dollar amount invested at an interest rate.</p></td></tr><tr><td style='padding: 15px;'><p>12. Module Summary</p><p style='margin: 0'>This 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.</p></td></tr></tbody></table><br><h4>2. Module 2</h4><p>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.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Module Objectives - Enabling our programs to make decisions based on input</p><p style='margin: 0'>This 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.</p></td></tr><tr><td style='padding: 15px;'><p>2. Strings</p><p style='margin: 0'>Continuing 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.</p></td></tr><tr><td style='padding: 15px;'><p>3. String Methods</p><p style='margin: 0'>In this video, we will learn about the two methods of assigning a string variable in Java programming.</p></td></tr><tr><td style='padding: 15px;'><p>4. Stringbuilder</p><p style='margin: 0'>Here, we will look at the StringBuilder, which creates a mutable or modifiable succession of characters in the strings class.</p></td></tr><tr><td style='padding: 15px;'><p>5. Type Casting</p><p style='margin: 0'>In 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.</p></td></tr><tr><td style='padding: 15px;'><p>6. Flow Control: IF/ELSE, Ternary Operator - Test Scores Program</p><p style='margin: 0'>We 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.</p></td></tr><tr><td style='padding: 15px;'><p>7. Flow Control: Switch Statement Program - Print Weekday Based On Number</p><p style='margin: 0'>Let's look at the SWITCH statement in this video, which is also a part of the decision-making tools in Java programming.</p></td></tr><tr><td style='padding: 15px;'><p>8. Flow Control: Loops - WHILE | DO-WHILE | FOR</p><p style='margin: 0'>Here, 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.</p></td></tr><tr><td style='padding: 15px;'><p>9. Flow Control: Loops - BREAK | CONTINUE</p><p style='margin: 0'>In this lesson, we will continue on loops and closely examine the BREAK and CONTINUE keywords and their implementation.</p></td></tr><tr><td style='padding: 15px;'><p>10. Arrays</p><p style='margin: 0'>In this video, we will learn about Java arrays, which store multiple values in a single variable instead of creating separate variables for each value.</p></td></tr><tr><td style='padding: 15px;'><p>11. Methods</p><p style='margin: 0'>We 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.</p></td></tr><tr><td style='padding: 15px;'><p>12. Program: Calculate Test Score Average</p><p style='margin: 0'>It is time to put all the knowledge we gained from the previous lessons into creating a program that tests the scoring average.</p></td></tr><tr><td style='padding: 15px;'><p>13. Program: Find Max Value In Array</p><p style='margin: 0'>Furthering our program writing skills, we will learn to create a program that determines the maximum value in an array.</p></td></tr><tr><td style='padding: 15px;'><p>14. Module Summary</p><p style='margin: 0'>This brief video succinctly summarizes what we learned throughout this module.</p></td></tr></tbody></table><br><h4>3. Module 3</h4><p>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.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Module Objectives - Understanding OOP Architecture and Design concepts</p><p style='margin: 0'>This brief video outlines the concepts we will learn in this module, including OOP architecture and design.</p></td></tr><tr><td style='padding: 15px;'><p>2. Classes & Objects</p><p style='margin: 0'>Here, we will understand what classes and objects are and which are the keys to object-oriented programming.</p></td></tr><tr><td style='padding: 15px;'><p>3. Constructors & Access Specifiers (Setters and Getters)</p><p style='margin: 0'>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.</p></td></tr><tr><td style='padding: 15px;'><p>4. The 4 Pillars Of OOP</p><p style='margin: 0'>This video illustrates the four major pillars of object-oriented programming: encapsulation, abstraction, polymorphism, and inheritance.</p></td></tr><tr><td style='padding: 15px;'><p>5. Inheritance</p><p style='margin: 0'>In 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.</p></td></tr><tr><td style='padding: 15px;'><p>6. Multi-level Inheritance, Polymorphism</p><p style='margin: 0'>Here, we will look at the multilevel inheritance of the classes and how we can share the attributes of many subclasses.</p></td></tr><tr><td style='padding: 15px;'><p>7. Abstract Class</p><p style='margin: 0'>This lesson will teach us how to create a class to represent concepts rather than objects.</p></td></tr><tr><td style='padding: 15px;'><p>8. Interfaces</p><p style='margin: 0'>This video elaborates on interfaces, how an interface determines the software's features, and how they can be implemented.</p></td></tr><tr><td style='padding: 15px;'><p>9. Const, Enum, Static, Final</p><p style='margin: 0'>In this lecture, we will learn about constants and static variables and how to create variables using the final and static methods.</p></td></tr><tr><td style='padding: 15px;'><p>10. Collections</p><p style='margin: 0'>Let's understand about Java collections framework designed to support numerous collections hierarchically.</p></td></tr><tr><td style='padding: 15px;'><p>11. Exception Handling</p><p style='margin: 0'>Here, 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.</p></td></tr><tr><td style='padding: 15px;'><p>12. File Handling</p><p style='margin: 0'>In this video, we will be looking at file and exception handling. We will wrap our file statements inside the try and catch blocks.</p></td></tr><tr><td style='padding: 15px;'><p>13. Program: Custom Message Based on Weekday</p><p style='margin: 0'>We 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.</p></td></tr><tr><td style='padding: 15px;'><p>14. Module Summary</p><p style='margin: 0'>This video briefly outlines the concepts learned in the module in a quick refresher.</p></td></tr></tbody></table><br><h4>4. Module 4</h4><p>In module four, we will look at sample real-world programs, use a UML diagram, and understand version control and GitHub integration.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Module Objectives - Designing real-world solutions based on UML diagrams</p><p style='margin: 0'>In 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.</p></td></tr><tr><td style='padding: 15px;'><p>2. Project: Payroll System Simulation - Part 1</p><p style='margin: 0'>This lesson will teach us to create a simple payroll management system. In this lesson, we will look at the program's basic structure.</p></td></tr><tr><td style='padding: 15px;'><p>3. Project: Payroll System Simulation - Part 2</p><p style='margin: 0'>We will continue with the second part of the payroll system and look at how to create changes or updates to the classes used.</p></td></tr><tr><td style='padding: 15px;'><p>4. Project: Payroll System Simulation - Part 3</p><p style='margin: 0'>In part 3 of the payroll system, we will look at using the paystub method for our employee classes created in the system.</p></td></tr><tr><td style='padding: 15px;'><p>5. Project: Payroll System Simulation - Part 4</p><p style='margin: 0'>In this video, we will be introduced to GitHub, where we will store our code for the payroll management system.</p></td></tr><tr><td style='padding: 15px;'><p>6. Project: Payroll System Simulation - Part 5</p><p style='margin: 0'>In 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.</p></td></tr><tr><td style='padding: 15px;'><p>7. Project: ATM Simulation Part 1 - Interface Example</p><p style='margin: 0'>This video demonstrates how to simulate a real-world ATM program using a UML example.</p></td></tr><tr><td style='padding: 15px;'><p>8. Project: ATM Simulation Part 2 - UI Menu</p><p style='margin: 0'>In 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.</p></td></tr><tr><td style='padding: 15px;'><p>9. Project: ATM Simulation Part 3 - Single Inheritance</p><p style='margin: 0'>This video focuses on rectifying the code using the break statement that will handle the unwanted comments appearing in the ATM system,</p></td></tr><tr><td style='padding: 15px;'><p>10. Project: ATM Simulation Part 4 - Transactions Report</p><p style='margin: 0'>We will continue further in the ATM project and implement the transaction portion of the ATM program.</p></td></tr><tr><td style='padding: 15px;'><p>11. Project: ATM Simulation Part 5 - GitHub Integration</p><p style='margin: 0'>We will check and execute our ATM simulation program and learn to upload the program on GitHub.</p></td></tr><tr><td style='padding: 15px;'><p>12. Module Summary</p><p style='margin: 0'></p></td></tr></tbody></table>

Java

Programming

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

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

Microsoft Teams

Agile

Project Management

Scrum

Microsoft Planner

JIRA

Trello

Dive into the world of project management with our comprehensive course! Master the fundamentals, explore advanced tools such as Jira, Microsoft Teams, and Trello, and gain real-world insights. From Agile methodologies to effective communication strategies, this course equips you with the skills to excel as a confident and successful project manager.

The Complete Project Management Fundamentals Course

Studyhub UK

Programming Fundamentals

Trainers Course

Complete Python Machine Learning & Data Science Fundamentals

<p dir="ltr" id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Take the next step in your career and become the financial expert your company needs. The Sage 50 Payroll Complete Course will teach you how to manage money effectively, even if you have no prior experience.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Learn how to handle complex financial transactions with confidence, whether you work as an accountant in a large financial firm or have a key role in a private company. This course will give you the skills and knowledge you need to succeed in the financial world.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Designed by industry experts, the course is more than just an education; it&#39;s a chance to enhance your understanding and advance your career to new levels.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Enrol in this well-structured program, and benefit from the guidance of experienced professionals. Your path to financial excellence starts here.</span></p><h2 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Learning Outcome of Sage 50 Payroll Complete Course&nbsp;</span></h2><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Master Sage 50 Payroll basics, covering settings, legislation, and pension schemes.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn payroll processing, including adding and managing employee records.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Gain proficiency in e-Submissions, year-end procedures, and advanced topics like global changes and holiday schemes.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand statutory sick pay, maternity pay, student loans, company cars, and workplace pensions.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Acquire skills in processing payroll for specific months, recording holidays, and linking payroll to accounts.</li></ul><h2 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Key Features of the Course</span></h2><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">A CPD certificate that is recognised worldwide.</span></li><li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">A great online learning experience.</span></li><li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Interesting and unique online materials and activities.</span></li><li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Expert guidance and support from the field leaders.</span></li><li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Access to the study resources anytime you want.</span></li><li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Friendly and helpful customer service and admin support by email, phone, and chat from Monday through Friday.</span></li><li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Get a year-long access to the course.</span></li></ul><h2 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Who is this course for</span></h2><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Sage 50 Payroll Complete Course &nbsp;Course is suitable for -</p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Suitable for individuals seeking a refresher course in financial management.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Ideal for beginners in company finances, especially those working in administration or accounting departments of large firms or organizations.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Valuable for existing accountants looking to enhance their skills or adopt a trusted financial management system.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(35, 35, 35); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 35);">Anyone interested in&nbsp;</span><span style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style="color: rgb(68, 68, 68);">Payroll Management <span style="color: rgb(65, 65, 65); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(65, 65, 65);"><span style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style="color: rgb(68, 68, 68);">and&nbsp;</span></span>Systems&nbsp;</span></li></ul><h2 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Requirements</span></h2><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(65, 65, 65); box-sizing: border-box;" fr-original-style="color:#414141;">Open to all interested in <span style="color: rgb(65, 65, 65); box-sizing: border-box;" id="isPasted" fr-original-style="color:#414141;"><span style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style="color: rgb(68, 68, 68);">Sage 50&nbsp;</span></span><span style="color: rgb(68, 68, 68); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(68, 68, 68);">Payroll Management</span></span></li><li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(65, 65, 65); box-sizing: border-box;" fr-original-style="color: rgb(65, 65, 65);">No prerequisites; suitable for individuals from any academic background.</span></li><li dir="ltr" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><span style="color: rgb(65, 65, 65); box-sizing: border-box;" fr-original-style="color: rgb(65, 65, 65);">Accessible course materials from any internet-enabled device.</span></li></ul><h2 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">CPD Certificate from Course Gate</span></h2><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style="color:#444444;">At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for &pound;9 and the hard copy for &pound;15. Also, you can order both PDF and hardcopy certificates for &pound;22.</span></p><h2 dir="ltr" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Career path</span></h2><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Payroll Manager</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Payroll Administrator</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Finance Administrator</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Financial Analyst</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">HR Assistant with Payroll Responsibilities</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Accounts Assistant</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Tax Accountant</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Bookkeeper</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Accounts Payable/Receivable Clerk</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Payroll Management Educator</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Please Note:</strong> For practice purpose, you should have Sage 50 software installed on your PC. The software is not included with this course.</p><div style="color: rgb(68, 68, 68); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(68, 68, 68);"><div style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);"><div data-elementor-type="wp-post" data-elementor-id="315766" data-elementor-post-type="course" fr-original-style="" style="box-sizing: border-box;"></div></div></div>

Course Gate

This course will teach you everything you need to know about Sage 50 Payroll, a powerful software for managing payroll and finances. Whether you are new to payroll or want to refresh your skills, this course will help you master the basics and the advanced features of Sage 50 Payroll. You will learn from experienced instructors, handle complex transactions, and boost your career prospects with a CPD certificate.

Sage 50 Payroll Complete Course

<p>This Ambulance and Emergency Care Assistant course is designed for paramedics or anyone who is interested in helping people by knowing how to respond well to a medical emergency.</p><p>In terms of emergency care, you will learn the basic first aid techniques like the Do's &amp; Don'ts, dressing, bandaging, CPR and how to use AED. You will also learn paediatric first aid, how to deal with people with injuries, illness, breathing problems, fractures and dislocations. As CPR and AED is important we have a separate course that will go in-depth on introducing you to both CPR &amp; AED and how they are done. Moreover, our course on manual handling hazards and injuries will ensure you know all the different types of injuries, common disorders and how to prevent both of them.</p><p>We also have included a unique course that focuses on fire, the importance of fire and how to deal with fire. This course will make sure you are more diverse than the other paramedics. Finally, for ambulance emergencies, we have a course that will teach you the basics of ambulance care like the roles, responsibilities and standards that have to be met. You will also learn about ambulance maintenance which will include climate control, oxygen system, onboard suction system, volt system and medical equipment.</p><p><strong>Learning Outcomes:</strong></p><p>By the end of the course, learners will be able to:</p><ul><li>Learn the Do's and Don't of basic first aid and how to respond to an emergency</li><li>Know what is paediatric first aid and how to take care of a child in case of an emergency</li><li>Learn what actions to take when a person is injured, has an illness and breathing problems</li><li>Identify fractures and dislocation of a patient and take necessary steps</li><li>Get introduced to pediatric &amp; adult CPR and how to conduct CPR on a patient</li><li>Know what to do to an unresponsive patient who is breathing as well as to an unresponsive patient who is not breathing</li><li>Learn the basics of ambulance care and the roles &amp; responsibilities of an ambulance care assistant</li><li>Understand the types of fire and why fire safety is important</li><li>Deepen their knowledge on manual handling injuries and hazards</li><li>Have in-depth knowledge of ambulance maintenance</li></ul><p><strong>Key Features Of Ambulance and Emergency Care Assistant Bundle Course</strong></p><ul><li><strong>CPD Certification Service (CPD UK) Accredited</strong></li><li>Instant e-certificate</li><li>Fully online, interactive course with audio voiceover</li><li>Developed by qualified professionals</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>*** Additional Gifts ***</strong></p><ul><li><strong>Free First Aid At Work Course</strong></li></ul><p><strong>Course Curriculum</strong></p><p>The detailed curriculum outline of our Ambulance and Emergency Care Assistant course is as follows:</p><p><strong>Module 01: Basic First Aid At Work Techniques </strong></p><ul><li>The Chain of Survival</li><li>The Do's and Don'ts of Basic First-Aid</li><li>First Aid Kit</li><li>How to use face shields?</li><li>How to put on a dressing</li><li>How to put on a bandage</li><li>How to bandage a hand</li><li>How to bandage a sprain</li><li>How to make an arm sling</li><li>How to Conduct CPR?</li><li>How to Use an AED?</li><li>Rescuing Someone from Water &amp; Fire</li><li>Recordkeeping</li></ul><p><strong>Module 02: Paediatric First Aid </strong></p><ul><li>What is Paediatric First Aid</li><li>Provision of First Aid in Early Years Settings</li><li>Role of First Aiders</li><li>Requirements in Childcare</li><li>Minimising the Risk of Infection</li><li>Personal Protective Equipment</li><li>First Aid Equipment</li><li>Storage and Administration of Medicines</li><li>Incident Recording and Reporting</li></ul><p><strong>Module 03: Secondary Illness: Breathing Problems</strong></p><ul><li>Common Breathing Problems and First Aid Tips for Each Problem</li></ul><p><strong>Module 04: Secondary Illnesses and Injuries</strong></p><ul><li>Common Secondary Illnesses and First Aid Tips for Each Problem</li></ul><p><strong>Module 05: Dealing With Fractures and Dislocations </strong></p><ul><li>The Human Skeleton</li><li>Types of Fractures</li><li>Head injuries</li><li>Spinal injuries</li><li>Fractures in children</li><li>Dislocations</li></ul><p><strong>Module 06: Loss of Responsiveness and CPR</strong></p><ul><li>Introduction to pediatric and adult CPR</li><li>CPR handover</li><li>Compressions Only CPR</li><li>AED Introduction</li><li>What to do When the Patient is Unresponsive and Breathing?</li><li>What to do When the Patient is Unresponsive and Not Breathing?</li></ul><p><strong>Module 07: Basics of Ambulance Care </strong></p><ul><li>Who Are Ambulance Care Assistants?</li><li>Day to Day Tasks of Ambulance Care Assistants</li><li>Roles and Responsibilities</li><li>Skills and Knowledge</li><li>Five principles of Ambulance Flow</li><li>The New Ambulance Standards</li></ul><p><strong>Module 08: Fire Safety</strong></p><ul><li>Introduction</li><li>Why Fire Safety is important</li><li>The Importance of Fire Safety</li><li>The Fire Triangle</li><li>The types of fires</li><li>Responsible Persons</li><li>Areas with the first 'Responsible Person'</li><li>First responsible person duties</li><li>Warden duties</li></ul><p><strong>Module 09: Manual Handling Hazards and Injuries</strong></p><ul><li>Types of Injury</li><li>Common Disorders and Immediate Injuries</li><li>Musculoskeletal Disorders (along with a short description of the musculoskeletal system)</li><li>How to Prevent Disorders?</li><li>Accident and Incident Reporting</li></ul><p><strong>Module 10: Ambulance Maintenance</strong></p><ul><li>Engine Compartment</li><li>Under Vehicle</li><li>Body</li><li>Front Switch Console</li><li>Main Electrical Control Centre</li><li>Patient Compartment Switch Console</li><li>Climate Control</li><li>Oxygen System</li><li>On-Board Suction System</li><li>Volt System</li><li>Modular Body</li><li>Interior of Module</li><li>Medical Equipment</li></ul><p><strong>Accreditation</strong></p><p>This course is fully <strong>CPD Certification Service (CPD UK) Accredited</strong>, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.</p><p><strong>Disclaimer:</strong> The CPD approved course is owned by E-Learning<br />Solutions Ltd and is distributed under license.</p><p><strong>Certification</strong></p><p>Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.</p><p><strong>Assessment</strong></p><p>At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        10 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by The CPD Certification Service
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is suitable for:</p><ul><li>Nursing Assistant</li><li>Care Manager</li><li>Emergency Care Support Worker</li><li>Ambulance Care Assistant</li><li>Care Home Manager</li><li>Paramedic</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>No formal qualification is required</p><p>Disclaimer: <em><strong>Please Note:</strong> This course is not a regulated course and doesn't provide any professional qualifications. This course aims to provide basic information about Paramedicine studies. </em></p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Head of Ambulance Operations: £50,428 - £54,631 per annum</li><li>Ambulance Preparation Staff: £13.40 per hour</li><li>Paramedic: £45,625 per annum</li><li>Emergency Call Handler: £10.41 - £17.57 per hour</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion (Hardcopy)</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.</p></div>
        <h4>Certificate of completion (PDF)</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Training Express

Ambulance and Emergency Care Assistant Training with First Aid At Work (EFAW) Refresher Course

Horsham

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Learn the skills, knowledge and have the confidence to tackle difficult conversations in a productive way.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><div data-section-id="1695042071629" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/77df68e-28e4-057f-41d6-ca1d3577146_Course_Overview_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></div></div><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><br id="isPasted" fr-original-style="" style="box-sizing: border-box;"></div><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course overview</strong><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration:&nbsp;</strong>1 day (6.5 hours)</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Do you worry about how to give negative feedback or deal with performance issues? Are you concerned about giving bad news? This workshop is designed to give you the skills, knowledge and confidence to tackle these scenarios in a productive way.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">If you are a people manager, team leader or supervisor looking to make those challenging conversations less stressful and more effective, this workshop is for you.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">Lots of practical sessions will ensure you have the opportunity to relate your learning to your real life work situations.</p><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);">The one day session will use professional actors in the afternoon so that you can practice handling real-life challenging conversations.</p><div data-aos="fade-up" data-aos-delay="500" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div></section></div><div data-section-id="1695042071630" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/8ba0826-4fb5-333c-0ea4-28c13064336b_Objectives_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></div></div><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Objectives</strong>&nbsp;<p style="color: rgb(89, 89, 89); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);">By the end of the course you will be able to:</p><ul style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><li fr-original-style="" style="box-sizing: border-box;">Deal with a wide range of challenging conversations</li><li fr-original-style="" style="box-sizing: border-box;">Describe the preferred behavioural style for giving feedback</li><li fr-original-style="" style="box-sizing: border-box;">State the most appropriate influencing technique to use in your situations</li><li fr-original-style="" style="box-sizing: border-box;">Explain how to give successful constructive feedback</li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></div></section></div><div data-section-id="1695042071631" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><img src="https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/cbd24e-e374-8bf2-2a2e-66ae236e51d4_Content_Icon.png" alt="" style="width: 80px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 80px;" fr-original-class="fr-draggable"></div></div><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-section-id="1695048787156" style="color: rgb(89, 89, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" fr-original-style="" style="box-sizing: border-box;"><div data-aos="fade-up" data-aos-delay="0" data-aos-duration="1500" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Content</h3><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">What are challenging conversations</h5><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">What type of challenging conversations occur?</li><li fr-original-style="" style="box-sizing: border-box;">Why do we find them challenging?</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Communication&nbsp;</h5><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practical exercise to demonstrate and act as a refresher of the fundamentals of communication</li><li fr-original-style="" style="box-sizing: border-box;">Barriers to communication especially in a difficult discussion</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Choosing the right behavioural style</h5><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Refresher of assertiveness and why it is important in this context</li><li fr-original-style="" style="box-sizing: border-box;">Practical exercise demonstrating how behaviour breeds behaviour, and the impact of choosing an inappropriate style</li><li fr-original-style="" style="box-sizing: border-box;">Steps to using assertive behaviour</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Influencing</h5><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Cialdini&rsquo;s model for influence</li><li fr-original-style="" style="box-sizing: border-box;">How to use influencing techniques in handling challenging conversations</li><li fr-original-style="" style="box-sizing: border-box;">Practical application</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Feedback&nbsp;</h5><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understanding feedback &ndash; positive vs. negative</li><li fr-original-style="" style="box-sizing: border-box;">Using the ABCBC model for feedback</li><li fr-original-style="" style="box-sizing: border-box;">Using the basics of emotional intelligence to give effective feedback</li><li fr-original-style="" style="box-sizing: border-box;">Practical application</li></ul><h5 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Practical Activities</h5><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Professional actors will work with you in small groups in the afternoon to practice real-life challenging conversations.</li></ul></div></div></section></div><div data-section-id="1695048787157" style="color: rgb(89, 89, 89); box-sizing: border-box;" fr-original-style=" color: rgb(89, 89, 89);"><section data-reveal-event="" data-reveal-offset="" data-reveal-units="seconds" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><br fr-original-style="" style="box-sizing: border-box;"></section></div></div></section></div>

Underscore Group

Handling challenging conversations

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Mental Health First Aid Refresher 4-hour training sessions</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Can you remember ALGEE?&nbsp;</strong>Mental Health Action Plan.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Revisit the key areas from the full course. Keep up to date with the latest statistics and information.</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is for those that have completed the MHFA England Mental Health First Aid or Champion course.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;"><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;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">FAQs</span></a></u></p>

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 Resilience

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 

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(62, 62, 62); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(62, 62, 62);">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.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style="color: rgb(62, 62, 62);"><span style="color: rgb(36, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(36, 35, 35);">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!</span><br fr-original-style="" style="box-sizing: border-box;"></span></p><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><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></p>

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

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T<span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">his 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;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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"></span></p><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);"><span data-key="22" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="22:0" fr-original-style="" style="box-sizing: border-box;">Target Audience</span></span></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.</p><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2><p data-key="28" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">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><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);"><span data-key="31" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="31:0" fr-original-style="" style="box-sizing: border-box;">Please note a recording of the course will&nbsp;</span><span data-offset-key="31:1" fr-original-style="" style="box-sizing: border-box;"><strong data-slate-leaf="true" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">not&nbsp;</strong></span><span data-offset-key="31:2" fr-original-style="" style="box-sizing: border-box;">be made available.</span></span></p><h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="36" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="36:0" fr-original-style="" style="box-sizing: border-box;">Speaker</span></span></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 180, 205); box-sizing: border-box;" fr-original-style="color: rgb(0, 180, 205);">Sarah Charlton, Consultant, DG Legal</span></strong></a></h3><p data-key="39" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><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.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

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

<p style="color: rgb(36, 35, 35); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(36, 35, 35);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">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</strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">. </strong></span></p><p style="color: rgb(36, 35, 35); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(36, 35, 35);">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.</p><p style="color: rgb(36, 35, 35); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(36, 35, 35);">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!</p><p style="text-align: center; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><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></p>

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

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course has been accredited by the CPD Accreditation Office for delivery, structure and content.</p>

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">Duration<p>1 Days</p><p>6 CPD hours</p><p>Writing 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.</p></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><br /><p>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. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 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.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Content Writing

Writing Skills

Book Writing

Business English

Business Writing

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">A real estate financial model is the abstract representation of an investment scenario. Building a Real Estate Financial Model requires theory, maths and excel.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">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.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This is an excellent starter/refresher course, whether you&rsquo;re a recent graduate or a mid/senior professional.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One:</strong></strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Conventional Valuations</strong></strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Cash Flow Models (Single-Let)</strong></strong></p><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;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">&ldquo;What If&rdquo;&nbsp;</em></em>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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Additional topics:</strong></strong></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Other Excel tips and tricks, including navigation and presentation:</strong></strong></p><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;"><br fr-original-style="" style="box-sizing: border-box;"></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></span></p><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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">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:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



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.

347 Courses delivered Online

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

The Complete Project Management Fundamentals Course

By Packt

Complete Python Machine Learning & Data Science Fundamentals

By Studyhub UK

Sage 50 Payroll Complete Course

By Course Gate

Ambulance and Emergency Care Assistant Training with First Aid At Work (EFAW) Refresher Course

By Training Express

Handling challenging conversations

By Underscore Group