Name: IASSC Lean Six Sigma Green Belt (Exam Included) – 12 Months Access
Price: 639 GBP
Availability: InStock

Central Milton

<div class="paragraph">E-Learning courses are self study courses which students can join from anywhere in the world. Students access each course via an app. and have access to the learning material for up to 6 months.</div>

E-Learning courses are self study courses which students can join from anywhere in the world. Students access each course via an app. and have access to the learning material for up to 6 months.

ELHUK

English Language Teaching

E-Learning courses are self study courses which students can join from anywhere in the world.

E-Learning English - Academic English - Self Access Course 

General admission

***Complete Microsoft Office Diploma || Microsoft Office Word | Microsoft Office PowerPoint | Microsoft Office Excel | Microsoft Access | Functional Skills IT | Admin, Secretarial & PA | Legal Secretary and Office Skills | Document Control and much more...
In today's competitive Job Market, possessing Microsoft Office skills is essential. Applicants must be proficient in Microsoft Office, regardless of the field. Additionally, you can choose a career as a Microsoft Office Specialist. In the UK, the average salary for a Microsoft Office Specialist (MOS) is £24.36 per hour, or £47,500 annually.
If you're searching for anything to boost your CV and help you stand out in this increasingly competitive job market, our Microsoft Office Skills (MS Excel, Word, PowerPoint, Access), Administration & IT Training bundle is just the right thing for you!
✿ 35 in 1 “Microsoft Office Skills (MS Excel, Word, PowerPoint, Access), Administration & IT Training” Mega Bundle ✿
Key Features of this Microsoft Office Skills Training from Skill Up:
CPD & CiQ Certified Mega Bundle
35 Free PDF Certificates
Worldwide accessibility to learning the Microsoft Office courses
This Microsoft Office Bundle is an entirely Online, interactive lessons with voiceover audio
Lifetime Access to the Microsoft Office bundle materials
24/7 Learner Support
Welcome to a transformative learning journey tailored to empower you with essential Microsoft Office Skills, Administration proficiency, and IT expertise. In this exclusive Microsoft Office Skills training, explore MS Excel, Word, PowerPoint, and Access, equipping you with indispensable tools to confidently navigate the digital landscape. Through engaging content and interactive learning, we unravel the intricacies of Microsoft Office Skills (MS Excel, Word, PowerPoint, Access), Administration & IT, providing a solid foundation for novices and those seeking to enhance their existing Microsoft Office skills.
As you delve into Microsoft Office Skills (MS Excel, Word, PowerPoint, Access), Administration & IT Training, our creative approach transcends traditional learning boundaries. We believe in the persuasive force of knowledge, fostering a stimulating environment where concepts are not just understood but embraced. The Microsoft Office bundle is not merely a guide; it's an invitation to unlock your potential in the realm of Microsoft Office, Administration, IT & Technology.
This Microsoft Office Skills (MS Excel, Word, PowerPoint, Access), Administration & IT Training Mega Bundle includes the following courses:
Course 01: Microsoft Word
Course 02: Microsoft Excel Complete Training
Course 03: Advanced PowerPoint Training
Course 04: Microsoft Access
Course 05: Next Level MS Outlook Skills
Course 06: Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes!
Course 07: Microsoft Word Advanced course
Course 08: MS Access Tables and Queries for Beginner
Course 09: MS Excel - Advanced Formulas and Functions
Course 10: MS Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
Course 11: Link Access Tables to Excel Spreadsheets
Course 12: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines
Course 13: Excel PowerQuery and PowerPivot
Course 14: Microsoft Excel Training: Depreciation Accounting
Course 15: Data Entry Administrator Training
Course 16: Data Analysis: PowerBI Formulas
Course 17: Data Analysis: Getting Results with PowerBI
Course 18: Data Analytics with Tableau
Course 19: Microsoft Power BI - Become a Power BI Pro in 90 Minutes!
Course 20: Excel Essentials for Office Administrators
Course 21: Secretarial, PA & Office Administration Diploma
Course 22: Office Skills and Administration
Course 23: Online Microsoft Excel Master Certification Course
Course 24: Proofreading & Copyediting
Course 25: Copywriting Secrets
Course 26: Touch Typing Masterclass
Course 27: Basic Data Analysis Training
Course 28: Cybersecurity: Data Protection and Privacy
Course 29: Document Control and Management
Course 30: Effective Remote Working Training
Additionally, you will be given access to the following career-focused courses:
Course 31: Career Development Training
Course 32: CV Writing and Interview Tricks
Course 33: Ace the Interview - Interview Prep That Makes a Difference
Course 34: Ultimate Video Job Interview Training
Course 35: Perfect LinkedIn Profile Creation Training
Join us on this Microsoft Office Skills (MS Excel, Word, PowerPoint, Access), Administration & IT Training, where each lesson is a stepping stone towards mastering the tools that drive modern workplaces.
Certificates
Digital Certificate
This bundle comes with a free CPD Accredited PDF Copy certificate+ Transcript (according to the Learner's Choice). For additional courses, it costs £14.99 per copy.
Hard Copy Certificate
Get CPD Accredited Hard Copy certificate for £19.99 per copy. The delivery fee for the Hard Copy certificate, however, is free for UK residents, whereas it costs £10 for international students as delivery charge.
Learning Benefits of Microsoft Office Skills, Administration & IT Training:
Master Microsoft Office Excel for data analysis and visualisation.
Create professional documents using Microsoft Office Word.
Develop engaging presentations with Microsoft Office PowerPoint.
Manage databases effectively using Microsoft Office Access.
Understand fundamental IT concepts and applications.
Enhance administrative skills for efficient office management.
Apply data management techniques for better decision-making.
Utilise advanced features of Microsoft Office applications.
Improve productivity through effective use of IT tools.
Implement best practices for office administration.
The Microsoft Office Skills (MS Excel, Word, PowerPoint, Access), Administration & IT Training provides a comprehensive education in essential office applications and administrative practices. Covering key Microsoft Office tools, this training enhances your ability to handle data, create documents, and present information effectively. Combined with IT and administrative training, it equips you with the skills necessary for efficient office management. Ideal for individuals seeking to enhance their professional toolkit, this Microsoft Office Skills diploma bundle offers essential insights and valuable expertise.
Who is this course for?
If you want to keep yourself afloat in a related field or further assess your learning, this Microsoft Office Skills (MS Excel, Word, PowerPoint, Access) bundle is for you. Enthusiasts who want to explore this discipline are also eligible for this bundle.
Students seeking to enhance their employability prospects
Professionals aiming to upgrade their Microsoft Office skills
Entrepreneurs and small business owners managing their operations
Administrators and office managers seeking workflow optimization
Individuals transitioning to new career paths
Requirements
Since no prior knowledge or experience is required to enrol in this Microsoft Office Skills diploma bundle.
Take your time to finish this Microsoft Office Skills (MS Excel, Word, PowerPoint, Access) training, and there is no deadline for the Bundle.
Career path
Unlock diverse career opportunities with our Microsoft Office Skills (MS Excel, Word, PowerPoint, Access), Administration & IT Training. Such as:
Microsoft Office Specialist (MOS): £37,000 - £67,000
Office Administrator: £20,000 - £35,000
Data Analyst: £25,000 - £50,000
IT Support Specialist: £20,000 - £40,000
Project Coordinator: £22,000 - £40,000
Database Manager: £30,000 - £55,000

Skill Up

Office Skills & Productivity

Professional Skills

IT Skills

Office Administration

Microsoft Office

Microsoft Office Skills (MS Excel, Word, PowerPoint, Access), Administration & IT Training

General Admission

What is Six Sigma?
 
Six Sigma is a set of techniques and tools for process improvement. It was introduced by engineer Bill Smith while working at Motorola in 1986. Jack Welch made it central to his business strategy at General Electric in 1995. Today it is used in many industrial sectors.
 
Six Sigma seeks to improve the quality of the output of a process by identifying and removing the causes of defects and minimizing variability in manufacturing and business processes. It uses a set of quality management methods, mainly empirical, statistical methods, and creates a special infrastructure of people within the organization, who are experts in these methods. Each Six Sigma project carried out within an organization follows a defined sequence of steps and has specific value targets, for example: reduce process cycle time, reduce pollution, reduce costs, increase customer satisfaction, and increase profits.


Key Points
 
Provided by an IASSC fully Accredited Training Organisation (ATO): Hudson
Exam fee paid for/included to sit the official IASSC exam and get certification from the IASSC
Exam retake in the event you fail the exam on the first attempt
Official exam can be sat at home or in the office
Upon successful completion of the final exam, you will receive a certification from the IASSC confirming you are fully Six Sigma Black Belt certified
12 months access to course material
Course Duration
Total duration: 145 hours
Course Features
 
Core Content:
Video based course material: Fully narrated by the tutor, this includes hundreds of illustrations, graphics, charts, diagrams, and added animations to illustrate learning concepts.
Course notes: Illustrated with images, tables, graphs, and diagrams, these can be downloaded and used off-line.
DMAIC case studies: We have developed illustrated PDF case studies covering one topic from each DMAIC phase to help solidify your knowledge of the six sigma methodology.
Video based project case study: This is a narrated case study focusing on the application of DMAIC tools and concepts in a commercial setting.
Pre-recorded exam prep webinars: These DMAIC webinars cover the entire IASSC body of knowledge (BOK), and will help reinforce what you have learnt on the course and prepare you for the final exam.
Assessments:
Interactive knowledge checks: As the name suggests, these are interactive knowledge checks – using drag and drop functionality. It’s a fun and easy way to help you grasp DMAIC.
Interactive DMAIC simulation: This is an animated and narrated simulation of a six sigma project. You are prompted to choose the correct course of action throughout your project journey.
Interactive quizzes: Test your knowledge after each DMAIC phase with this multiple choice set of quizzes.
Practice test papers: These downloadable practice test papers will help prepare you for the final exam.
IASSC online practice test (20-day access): Developed by the IASSC, this will better help to prepare you for the final exam.
IASSC Exam: The exam fee is covered in the course price.
Resources:
Interactive forums with other students: Reach out to other students, start your own posts, ask questions, discuss six sigma topics, and share your six sigma work.
Downloadable six sigma templates: We have created a series of downloadable Excel templates that you can use during and after the course. You’ll find many of these discussed within the course. They can be used to apply your six sigma skills or utilised during a project.
Live Q&A webinars: These run once a month with the tutor. They include access to previous webinars.
Video based Minitab DMAIC exercises: This is an excellent resource to help cement your understanding of six sigma concepts, but also help you understand how to apply your six sigma skills in the real world. After watching the video tutorials, you’ll be prompted to perform the exercises.
Course Syllabus
 
Hudson Intro
Hudson Intro
Welcome & Instructions on Using this Course
Welcome & Instructions on Using this Course
A Note on Accessing the Quizzes
A Note on Attending the Webinars
IASSC Lean Six Sigma Black Belt: COURSE NOTES
DEFINE – IASSC Lean Six Sigma Black Belt – Course Notes
MEASURE – IASSC Lean Six Sigma Black Belt – Course Notes
ANALYSE – IASSC Lean Six Sigma Black Belt – Course Notes
IMPROVE – IASSC Lean Six Sigma Black Belt – Course Notes
CONTROL – IASSC Lean Six Sigma Black Belt – Course Notes
Content Exclusively Covered in the Course Notes
IASSC Lean Six Sigma Black Belt: INTRODUCTION
INTRODUCTION
IASSC Lean Six Sigma Black Belt: DEFINE PHASE
DEFINE – Phase Intro
1.00 DEFINE – Course Structure
1.01 DEFINE – Introduction to Six Sigma
1.02 DEFINE – Steps & Tools
1.03 DEFINE – The Cost of Poor Quality
1.04 DEFINE – Six Sigma Metrics
1.05 DEFINE – Lean
1.06 DEFINE – Project Charter
1.07 DEFINE – Phase Summary
1.08 DEFINE – Case Study: Building a Business Case
1.10 DEFINE – Case Study: Pareto Chart Applications
1.11 DEFINE – Knowledge Check 1 (4 tasks)
1.13 DEFINE – Knowledge Check 2 (4 tasks)
1.12 DEFINE – Knowledge Check 3 (1 task)
1.14 DEFINE – Knowledge Check 4 (1 task)
1.15 DEFINE – Quiz
IASSC Lean Six Sigma Black Belt: MEASURE PHASE
MEASURE – Phase Intro
2.00 MEASURE – Course Structure
2.01 MEASURE – Process Mapping Overview
2.02 MEASURE – Types of Process Map
2.03 MEASURE – Inputs to the Process
2.04 MEASURE – Cause & Effect Diagrams
2.05 MEASURE – X-Y Matrix
2.06 MEASURE – FMEA
2.07 MEASURE – Basic Statistics – Part 1
2.08 MEASURE – Basic Statistics – Part 2
2.09 MEASURE – Graphs
2.10 MEASURE – Measurement Systems Analysis (MSA) Overview
2.11 MEASURE – Measurement Systems Analysis – Continuous Data
2.12 MEASURE – Measurement Systems Analysis – Quantitative Data
2.13 MEASURE – Stability
2.14 MEASURE – Capability Analysis
2.14 (a) MEASURE – Calculating Capability Statistics (by Tamela Serensits – Master of Applied Statistics M.A.S)
2.15 MEASURE – Capability Analysis – Non-Normal Data
2.16 MEASURE – Phase Summary
2.17 MEASURE – Case Study: Measurement System Analysis
2.18 MEASURE – Knowledge Check 1 (4 tasks)
2.20 MEASURE – Knowledge Check 2 (4 tasks)
2.19 MEASURE – Knowledge Check 3 (1 task)
2.21 MEASURE – Knowledge Check 4 (1 task)
2.22 MEASURE – Quiz
IASSC Lean Six Sigma Black Belt: ANALYSE PHASE
ANALYSE – Phase Intro
3.00 ANALYSE – Course Structure
3.01 ANALYSE – Overview
3.02 ANALYSE – Multi-vari Analysis
3.03 ANALYSE – Classes of Distributions
3.04 ANALYSE – Hypothesis Testing
3.05 ANALYSE – Sample Variance & Population Variance
3.06 ANALYSE – Continuous Output Data – Comparing Two Samples
3.07 ANALYSE – Continuous Output Data – Comparing More than Two Samples
3.08 ANALYSE – Continuous Output Data – Testing a Sample Against a Standard
3.09 ANALYSE – Tests for Non-Continuous Output Data
3.10 ANALYSE – Test for Equal Variance
3.11 ANALYSE – Phase Summary
3.12 ANALYSE – Case Study: The Box Plot
3.13 ANALYSE – Knowledge Check 1 (4 tasks)
3.15 ANALYSE – Knowledge Check 2 (4 tasks)
3.14 ANALYSE – Knowledge Check 3 (1 task)
3.16 ANALYSE – Knowledge Check 4 (1 task)
3.17 ANALYSE – Quiz
IASSC Lean Six Sigma Black Belt: IMPROVE PHASE
IMPROVE – Phase Intro
4.00 IMPROVE – Course Structure
4.01 IMPROVE – Regression Analysis
4.02 IMPROVE – Multiple Regression
4.03 IMPROVE – Design of Experiments
4.04 IMPROVE – Full and Fractional Factorials
4.05 IMPROVE – Concept Generation
4.06 IMPROVE – Implementation
4.07 IMPROVE – Phase Summary
4.08 IMPROVE – Case Study: Regression Analysis
4.09 IMPROVE – Knowledge Check 1 (4 tasks)
4.11 IMPROVE – Knowledge Check 2 (4 tasks)
4.10 IMPROVE – Knowledge Check 3 (1 task)
4.12 IMPROVE – Knowledge Check 4 (1 task)
4.13 IMPROVE – Quiz
IASSC Lean Six Sigma Black Belt: CONTROL PHASE
CONTROL – Phase Intro
5.00 CONTROL – Course Structure and Overview
5.01 CONTROL – Final Capability, Lean Controls
5.02 CONTROL – Control Plans
5.03 CONTROL – Center Line & Control Limit Calculation, Control Plans
5.04 CONTROL – Phase Summary
5.05 CONTROL – Case Study: The Control Plan
5.06 CONTROL – Knowledge Check 1 (4 tasks)
5.08 CONTROL – Knowledge Check 2 (4 tasks)
5.07 CONTROL – Knowledge Check 3 (1 task)
5.09 CONTROL – Knowledge Check 4 (1 task)
5.10 CONTROL – Quiz
IASSC Lean Six Sigma Black Belt: CONCLUSION
CONCLUSION
Six Sigma DMAIC Project Case Study
DMAIC Project Case Study: Reducing Shirt Defect Rates
Six Sigma DMAIC Simulation
DMAIC Simulation
IASSC Lean Six Sigma Exam Prep Webinars
IASSC Lean Six Sigma Exam Prep – DEFINE
IASSC Lean Six Sigma Exam Prep – MEASURE
IASSC Lean Six Sigma Exam Prep – ANALYSE
IASSC Lean Six Sigma Exam Prep – IMPROVE
IASSC Lean Six Sigma Exam Prep – CONTROL
IASSC Lean Six Sigma Black Belt: SAMPLE TEST PAPERS
Sample Test Paper 1 – Questions and Answers
Sample Test Paper 2 – Questions
Sample Test Paper 2 – Questions and Answers
Sample Test Paper 3 – Questions
Sample Test Paper 3 – Questions and Answers
Sample Test Paper 4 – Questions
Sample Test Paper 4 – Questions and Answers
Sample Test Paper 5 – Questions
Sample Test Paper 5 – Questions and Answers
Sample Test Paper 6 – Questions
Sample Test Paper 6 – Questions and Answers
RESOURCE: Six Sigma Exam Reference Document
IASSC Examination Reference Document
RESOURCE: Six Sigma DMAIC Excel Templates
DEFINE Templates
MEASURE Templates
ANALYSE Templates
IMPROVE Templates
CONTROL Templates
RESOURCE: Six Sigma Minitab Exercises
WEBINAR (with Tamela Serensits). TOPIC: Introduction to Minitab
Minitab Exercises – Series Intro
DEFINE Minitab Exercises
MEASURE Minitab Exercises
ANALYSE Minitab Exercises
IMPROVE Minitab Exercises
CONTROL Minitab Exercises
RESOURCE: Six Sigma Webinars
Six Sigma: How to Apply it in the Real World
Six Sigma: DMADV

Hudson

IASSC lean six sigma black belt course. Online, 24/7 access to content and exam. Fee includes learning content, live webinars, tutor support, and official IASSC exam.

IASSC Lean Six Sigma Black Belt (Exam Included) – 12 Months Access

E-Learning English - General English B1 - Self Access Course 

E-Learning English - General English C1 - Self Access Course 

E-Learning English - General English B2 - Self Access Course 

E-Learning English - General English A1 -  Self Access Course  

E-Learning English - General English A2 - Self Access Course 

<h2><strong>Course Overview:</strong></h2>
<p> 
<strong>Discover the power of Microsoft Office Essentials with our Level 2 Microsoft Office Essentials Course.</strong> In today's digital age, proficiency in Microsoft Office is no longer a mere advantage; it has become an essential skill for success in nearly every industry. <strong>According to recent surveys, over 80% of job listings require proficiency in Microsoft Office, with Excel, Word, PowerPoint, and Access being the most sought-after applications.</strong> As the workplace evolves, the demand for individuals with advanced knowledge of these tools rapidly increases. 
</p> 
<p> 
<strong>Our comprehensive Level 2 Counselling Course allows you to navigate the complexities of Microsoft Office with ease and confidence. Designed to cater to beginners and intermediate users, this course offers a step-by-step approach to mastering Excel, Word, PowerPoint, and Access.</strong> You will delve into various topics, including creating and saving workbooks, formatting text and data, managing worksheets, creating impactful presentations, and building robust databases.
</p> 
<p> 
Enrol today in our Level 2 Microsoft Office Essentials course and unlock a world of opportunities, increased productivity, and career growth!
 </p> 
<hr />

<h2><strong>Key Features of the Course:</strong></h2>
<ul>
 	<li>CPD certificate upon successful completion</li>
 	<li>24/7 Learning Assistance for continuous support and guidance</li>
</ul>

<hr />

<h2><strong>Who is This Course For?</strong></h2>
<p> 
This course is ideal for individuals at various stages of their careers, including professionals seeking to enhance their Microsoft Office skills, students aiming to improve their employability, and anyone who wants to boost their productivity and efficiency in the workplace.
</p> 
<hr />

<h2><strong>What You Will Learn:</strong></h2>
<p> 
Throughout this Level 2 Microsoft Office Essentials course, you will <strong>develop a solid foundation in Microsoft Office essentials. Starting with Excel, you will learn to navigate the user interface, create and format spreadsheets, apply formulas and functions, and customise the appearance of your data. In Word, you will master document creation, formatting, and editing, as well as utilising advanced features like tables, symbols, and images. PowerPoint will enable you to create captivating presentations, while Access will equip you with the skills to build and manage databases effectively.</strong>
</p> 

<hr />

<h2><strong>Why Enrol in This Course:</strong></h2>
<p> 
The course has good reviewed content and a recently updated curriculum that ensures you gain the most relevant knowledge aligned with industry trends. Develop in-demand skills employers seek, boosting your career advancement and employability. Experience time-efficient learning with our structured approach, allowing you to achieve proficiency in Microsoft Office essentials quickly.
 </p> 
<hr />

<h2><strong>Requirements:</strong></h2>
<p> 
No prior experience or expertise is necessary to enrol in this course. Basic computer literacy and access to Microsoft Office applications will be beneficial.
 </p> 
<hr />

<h2><strong>Career Path:</strong></h2>
<p> 
Upon completion of this course, you can pursue various professions, including:
 </p> 
<ul>
 	<li>Administrative Assistant (£20,000 - £25,000 per annum)</li>
 	<li>Data Entry Operator (£18,000 - £22,000 per annum)</li>
 	<li>Office Manager (£25,000 - £35,000 per annum)</li>
 	<li>Project Coordinator (£25,000 - £35,000 per annum)</li>
 	<li>Database Administrator (£30,000 - £45,000 per annum)</li>
 	<li>Executive Assistant (£25,000 - £40,000 per annum)</li>
 	<li>Business Analyst (£35,000 - £50,000 per annum)</li>
</ul>

<hr />

<h2><strong>Certification:</strong></h2>
<p> 
Upon completing the course, you <strong>will receive a CPD certificate,</strong> demonstrating your proficiency in Microsoft Office essentials and enhancing your professional credibility.
 </p> 
<hr /> <h3>Course Curriculum</h3><div><p>32 sections • 96 lectures • 16:31:00 total length</p></div><div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Navigate the Excel User Interfact: 00:28:00</p></div><div><div><p>•Use Excel Commands: 00:10:00</p></div><div><div><p>•Create and Save a Basic Workbook: 00:19:00</p></div><div><div><p>•Enter Cell Data: 00:12:00</p></div><div><div><p>•Use Excel Help: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Worksheet Formulas: 00:15:00</p></div><div><div><p>•Insert Functions: 00:17:00</p></div><div><div><p>•Reuse Formulas and Functions: 00:17:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00</p></div><div><div><p>•Search for and Replace Data: 00:09:00</p></div><div><div><p>•Use Proofing and Research Tools: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Text Formats: 00:16:00</p></div><div><div><p>•Apply Number Format: 00:08:00</p></div><div><div><p>•Align Cell Contents: 00:09:00</p></div><div><div><p>•Apply Styles and Themes: 00:12:00</p></div><div><div><p>•Apply Basic Conditional Formatting: 00:11:00</p></div><div><div><p>•Create and Use Templates: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Preview and Print a Workbook: 00:11:00</p></div><div><div><p>•Set Up the Page Layout: 00:09:00</p></div><div><div><p>•Configure Headers and Footers: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Manage Worksheets: 00:05:00</p></div><div><div><p>•Manage Workbook and Worksheet Views: 00:07:00</p></div><div><div><p>•Manage Workbook Properties: 00:06:00</p></div></div></div></div></div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Navigate in Microsoft Word: 00:12:00</p></div><div><div><p>•Create and Save Word Documents: 00:24:00</p></div><div><div><p>•Manage Your Workspace: 00:06:00</p></div><div><div><p>•Edit Documents: 00:16:00</p></div><div><div><p>•Preview and Print Documents: 00:04:00</p></div><div><div><p>•Customize the Word Environment: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Character Formatting: 00:17:00</p></div><div><div><p>•Control Paragraph Layout: 00:19:00</p></div><div><div><p>•Align Text Using Tabs: 00:07:00</p></div><div><div><p>•Display Text in Bulleted or Numbered Lists: 00:03:00</p></div><div><div><p>•Apply Borders and Shading: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Make Repetitive Edits: 00:06:00</p></div><div><div><p>•Apply Repetitive Formatting: 00:10:00</p></div><div><div><p>•Use Styles to Streamline Repetitive Formatting Tasks: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Sort a List: 00:05:00</p></div><div><div><p>•Format a List: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert a Table: 00:07:00</p></div><div><div><p>•Modify a Table: 00:06:00</p></div><div><div><p>•Format a Table: 00:03:00</p></div><div><div><p>•Convert Text to a Table: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert Symbols and Special Characters: 00:04:00</p></div><div><div><p>•Add Images to a Document: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply a Page Border and Color: 00:03:00</p></div><div><div><p>•Add Headers and Footers: 00:06:00</p></div><div><div><p>•Control Page Layout: 00:05:00</p></div><div><div><p>•Add a Watermark: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Check Spelling Grammar and Readability: 00:07:00</p></div><div><div><p>•Use Research Tools: 00:06:00</p></div><div><div><p>•Check Accessibility: 00:03:00</p></div><div><div><p>•Save a Document to Other Formats: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Workbooks - Microsoft Word 2016 (Beginner): 00:00:00</p></div></div></div></div></div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Navigate the PowerPoint Environment: 00:28:00</p></div><div><div><p>•View and Navigate a Presentation: 00:15:00</p></div><div><div><p>•Create and Save a PowerPoint Presentation: 00:13:00</p></div><div><div><p>•Use PowerPoint Help: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Select a Presentation Type: 00:08:00</p></div><div><div><p>•Edit Text: 00:13:00</p></div><div><div><p>•Build a Presentation: 00:27:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Format Characters: 00:11:00</p></div><div><div><p>•Format Paragraphs: 00:16:00</p></div><div><div><p>•Format Text Boxes: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert Images: 00:10:00</p></div><div><div><p>•Insert Shapes: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Edit Objects: 00:16:00</p></div><div><div><p>•Format Objects: 00:06:00</p></div><div><div><p>•Group Objects: 00:04:00</p></div><div><div><p>•Arrange Objects: 00:07:00</p></div><div><div><p>•Animate Objects: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Table: 00:09:00</p></div><div><div><p>•Insert a Table from Other Microsoft Office Applications: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Chart: 00:10:00</p></div><div><div><p>•Format a Chart: 00:10:00</p></div><div><div><p>•Insert a Chart from Microsoft Excel: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Review Your Presentation: 00:11:00</p></div><div><div><p>•Apply Transitions: 00:05:00</p></div><div><div><p>•Print Your Presentation: 00:05:00</p></div><div><div><p>•Deliver Your Presentation: 00:08:00</p></div></div></div></div></div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Orientation to Microsoft Access1: 00:39:00</p></div><div><div><p>•Create a Simple Access Database: 00:10:00</p></div><div><div><p>•Get Help and Configure Options in Microsoft Access: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Modify Table Data: 00:17:00</p></div><div><div><p>•Sort and Filter Records: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Basic Queries: 00:15:00</p></div><div><div><p>•Sort and Filter Data in a Query: 00:14:00</p></div><div><div><p>•Perform Calculations in a Query: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Basic Access Forms: 00:07:00</p></div><div><div><p>•Work with Data on Access Forms: 00:23:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Report: 00:23:00</p></div><div><div><p>•Add Controls to a Report: 00:12:00</p></div><div><div><p>•Enhance the Appearance of a Report: 00:05:00</p></div><div><div><p>•Prepare a Report for Print: 00:03:00</p></div><div><div><p>•Organize Report Information: 00:15:00</p></div><div><div><p>•Format Reports: 00:12:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Overview:
Discover the power of Microsoft Office with our Level 2 Microsoft Office Essentials Course.
In today's digital age, proficiency in Microsoft Office is no longer a mere advantage; it has become an essential skill for success in nearly every industry. According to recent surveys, over 80% of job listings require proficiency in Microsoft Office, with Excel, Word, PowerPoint and Access being the most sought-after applications. As the workplace evolves, the demand for individuals with advanced knowledge of Microsoft Office tools rapidly increases. 
Our comprehensive Level 2 Microsoft Office Essentials Course allows you to navigate the complexities of Microsoft Office with ease and confidence. Designed to cater to beginners and intermediate users, this course offers a step-by-step approach to mastering Excel, Word, PowerPoint and Access. You will get into various topics, including creating and saving workbooks, formatting text and data, managing worksheets, creating impactful presentations, and building robust databases all with the help of Microsoft Office.
Enroll today in our Level 2 Microsoft Office Essentials course and unlock a world of opportunities, increased productivity, and career growth! 
Learning outcomes of the course are:
Develop a solid foundation in Microsoft Office Essentials.
Learn to navigate the Excel user interface, create and format spreadsheets, apply formulas and functions, and customize data appearance.
Master document creation, formatting, and editing in Word, using advanced features like tables, symbols, and images.
Create captivating presentations with PowerPoint.
Build and manage databases effectively using Access.
Key Features of the Course:
FREE Microsoft Office CPD-accredited certificate
Get a free student ID card with Microsoft Office training (£10 applicable for international delivery)
Lifetime access to the Microsoft Office course materials
The Microsoft Office program comes with 24/7 tutor support
Get instant access to this Microsoft Office course
Learn Microsoft Office training from anywhere in the world
The Microsoft Office training is affordable and simple to understand
The Microsoft Office training is an entirely online
Certification:
Upon completing the course, you will receive a CPD certificate, demonstrating your proficiency in Microsoft Office essentials and enhancing your professional credibility. 
Description
Begin your journey with Apex Learning right away!
The Level 2 Microsoft Office Essentials course teaches you how to use key Microsoft Office tools like Excel, Word, PowerPoint, and Access. You’ll learn how to create and format documents, spreadsheets, and presentations, apply formulas, and manage databases. This course is perfect for anyone looking to improve their Microsoft Office skills and boost workplace productivity.
Course Curriculum:
32 sections • 96 lectures • 16:31:00  hours total 
•Navigate the Excel User Interface
•Use Excel Commands
•Create and Save a Basic Workbook
•Enter Cell Data
•Use Excel Help
•Create Worksheet Formulas
•Insert Functions
•Reuse Formulas and Functions
•Insert, Delete, and Adjust Cells, Columns, and Rows
•Search for and Replace Data
•Use Proofing and Research Tools
•Apply Text Formats
•Apply Number Format
•Align Cell Contents
•Apply Styles and Themes
•Apply Basic Conditional Formatting
•Create and Use Templates
•Preview and Print a Workbook
•Set Up the Page Layout
•Configure Headers and Footers
•Manage Worksheets
•Manage Workbook and Worksheet Views
•Manage Workbook Properties
•Navigate in Microsoft Word
•Create and Save Word Documents
•Manage Your Workspace
•Edit Documents
•Preview and Print Documents
•Customize the Word Environment
•Apply Character Formatting
•Control Paragraph Layout
•Align Text Using Tabs
•Display Text in Bulleted or Numbered Lists
•Apply Borders and Shading
•Make Repetitive Edits
•Apply Repetitive Formatting
•Use Styles to Streamline Repetitive Formatting Tasks
•Sort a List
•Format a List
•Insert a Table
•Modify a Table
•Format a Table
•Convert Text to a Table
•Insert Symbols and Special Characters
•Add Images to a Document
•Apply a Page Border and Color
•Add Headers and Footers
•Control Page Layout
•Add a Watermark
•Check Spelling Grammar and Readability
•Use Research Tools
•Save a Document to Other Formats
•Workbooks - Microsoft Word 2016 (Beginner)
•Navigate the PowerPoint Environment
•View and Navigate a Presentation
•Create and Save a PowerPoint Presentation
•Use PowerPoint Help
•Select a Presentation Type:
•Edit Text
•Build a Presentation
•Format Characters
•Format Paragraphs
•Format Text Boxes
•Insert Images
•Insert Shapes
•Edit Objects
•Format Objects
•Group Objects
•Arrange Objects
•Animate Objects
•Create a Table
•Insert a Table from Other Microsoft Office Applications
•Create a Chart
•Format a Chart
•Insert a Chart from Microsoft Excel
•Review Your Presentation
•Apply Transitions
•Print Your Presentation
•Deliver Your Presentation
•Orientation to Microsoft Access1
•Create a Simple Access Database
•Get Help and Configure Options in Microsoft Access
•Modify Table Data
•Sort and Filter Records
•Create Basic Queries
•Sort and Filter Data in a Query
•Perform Calculations in a Query
•Create Basic Access Forms
•Work with Data on Access Forms
•Create a Report
•Add Controls to a Report
•Enhance the Appearance of a Report
•Prepare a Report for Print
•Organize Report Information
•Format Reports
Why Enroll in This Course?
This Microsoft Office course is ideal for individuals at different stages of their careers. This course is great for people new to Microsoft Office or those who want to improve their skills. It’s perfect for professionals wanting to improve their expertise, students looking to get better job opportunities, and anyone who wants to work more efficiently. The course will equip you with essential Microsoft Office skills for handling tasks in Excel, Word, PowerPoint, and Access.
Who is This Course For?
This Microsoft Office course is ideal for individuals at various stages of their careers, including professionals seeking to enhance their Microsoft Office skills, students aiming to improve their employability, and anyone who wants to boost their productivity and efficiency in the workplace.
Requirements:
No prior experience or expertise is necessary to enroll in this Microsoft Office course. Basic computer literacy and access to Microsoft Office applications will be beneficial. 
Career Path:
 Upon completion of this course, you can pursue various professions, including: 
Administrative Assistant (£20,000 - £25,000 per annum)
Microsoft Office Specialist [MOS] (£18,000 - £22,000 per annum)
Office Manager (£25,000 - £35,000 per annum)
Project Coordinator (£25,000 - £35,000 per annum)
Data Entry Operator (£20,000 - £28,000 per annum)
Executive Assistant (£25,000 - £40,000 per annum)
Business Analyst (£35,000 - £50,000 per annum)


Apex Learning

Microsoft Certification

Microsoft 365

Office Skills

Microsoft Excel

Microsoft Access

Microsoft Word

Level 2 Microsoft Office Essentials

What is Six Sigma?
 
Six Sigma is a set of techniques and tools for process improvement. It was introduced by engineer Bill Smith while working at Motorola in 1986. Jack Welch made it central to his business strategy at General Electric in 1995. Today it is used in many industrial sectors.
 
Six Sigma seeks to improve the quality of the output of a process by identifying and removing the causes of defects and minimizing variability in manufacturing and business processes. It uses a set of quality management methods, mainly empirical, statistical methods, and creates a special infrastructure of people within the organization, who are experts in these methods. Each Six Sigma project carried out within an organization follows a defined sequence of steps and has specific value targets, for example: reduce process cycle time, reduce pollution, reduce costs, increase customer satisfaction, and increase profits.


Key Points
 
Provided by an IASSC fully Accredited Training Organisation (ATO): Hudson
Exam fee paid for/included to sit the official IASSC exam and get certification from the IASSC
Exam retake in the event you fail the exam on the first attempt
Official exam can be sat at home or in the office
Upon successful completion of the final exam, you will receive a certification from the IASSC confirming you are fully Six Sigma Green Belt certified
12 months access to course material
Course Duration
Total duration: 136 hours
Course Features
 
Core Content:
Video based course material: Fully narrated by the tutor, this includes hundreds of illustrations, graphics, charts, diagrams, and added animations to illustrate learning concepts.
Course notes: Illustrated with images, tables, graphs, and diagrams, these can be downloaded and used off-line.
DMAIC case studies: We have developed illustrated PDF case studies covering one topic from each DMAIC phase to help solidify your knowledge of the six sigma methodology.
Video based project case study: This is a narrated case study focusing on the application of DMAIC tools and concepts in a commercial setting.
Pre-recorded exam prep webinars: These DMAIC webinars cover the entire IASSC body of knowledge (BOK), and will help reinforce what you have learnt on the course and prepare you for the final exam.
Assessments:
Interactive knowledge checks: As the name suggests, these are interactive knowledge checks – using drag and drop functionality. It’s a fun and easy way to help you grasp DMAIC.
Interactive DMAIC simulation: This is an animated and narrated simulation of a six sigma project. You are prompted to choose the correct course of action throughout your project journey.
Interactive quizzes: Test your knowledge after each DMAIC phase with this multiple choice set of quizzes.
Practice test papers: These downloadable practice test papers will help prepare you for the final exam.
IASSC online practice test (20-day access): Developed by the IASSC, this will better help to prepare you for the final exam.
IASSC Exam: The exam fee is covered in the course price.
Resources:
Interactive forums with other students: Reach out to other students, start your own posts, ask questions, discuss six sigma topics, and share your six sigma work.
Downloadable six sigma templates: We have created a series of downloadable Excel templates that you can use during and after the course. You’ll find many of these discussed within the course. They can be used to apply your six sigma skills or utilised during a project.
Live Q&A webinars: These run once a month with the tutor. They include access to previous webinars.
Video based Minitab DMAIC exercises: This is an excellent resource to help cement your understanding of six sigma concepts, but also help you understand how to apply your six sigma skills in the real world. After watching the video tutorials, you’ll be prompted to perform the exercises.
Course Syllabus
 
Hudson Intro
Hudson Intro
Welcome & Instructions on Using this Course
Welcome & Instructions on Using this Course
A Note on Accessing the Quizzes
A Note on Attending the Webinars
IASSC Lean Six Sigma Green Belt: COURSE NOTES
DEFINE – IASSC Lean Six Sigma Green Belt – Course Notes
MEASURE – IASSC Lean Six Sigma Green Belt – Course Notes
ANALYSE – IASSC Lean Six Sigma Green Belt – Course Notes
IMPROVE – IASSC Lean Six Sigma Green Belt – Course Notes
CONTROL – IASSC Lean Six Sigma Green Belt – Course Notes
Content Exclusively Covered in the Course Notes
IASSC Lean Six Sigma Green Belt: INTRODUCTION
INTRODUCTION
IASSC Lean Six Sigma Green Belt: DEFINE PHASE
DEFINE – Phase Intro
1.00 DEFINE – Course Structure
1.01 DEFINE – Introduction to Six Sigma
1.02 DEFINE – Steps & Tools
1.03 DEFINE – The Cost of Poor Quality
1.04 DEFINE – Six Sigma Metrics
1.05 DEFINE – Lean
1.06 DEFINE – Project Charter
1.07 DEFINE – Phase Summary
1.08 DEFINE – Case Study: Building a Business Case
1.10 DEFINE – Case Study: Pareto Chart Applications
1.11 DEFINE – Knowledge Check 1 (4 tasks)
1.13 DEFINE – Knowledge Check 2 (4 tasks)
1.12 DEFINE – Knowledge Check 3 (1 task)
1.14 DEFINE – Knowledge Check 4 (1 task)
1.15 DEFINE – Quiz
IASSC Lean Six Sigma Green Belt: MEASURE PHASE
MEASURE – Phase Intro
2.00 MEASURE – Course Structure
2.01 MEASURE – Process Mapping Overview
2.02 MEASURE – Types of Process Map
2.03 MEASURE – Inputs to the Process
2.04 MEASURE – Cause & Effect Diagrams
2.05 MEASURE – X-Y Matrix
2.06 MEASURE – FMEA
2.07 MEASURE – Basic Statistics – Part 1
2.08 MEASURE – Basic Statistics – Part 2
2.09 MEASURE – Graphs
2.10 MEASURE – Measurement Systems Analysis (MSA) Overview
2.11 MEASURE – Measurement Systems Analysis – Continuous Data
2.12 MEASURE – Measurement Systems Analysis – Quantitative Data
2.13 MEASURE – Stability
2.14 MEASURE – Capability Analysis
2.14 (a) MEASURE – Calculating Capability Statistics (by Tamela Serensits – Master of Applied Statistics M.A.S)
2.15 MEASURE – Capability Analysis – Non-Normal Data
2.16 MEASURE – Phase Summary
2.17 MEASURE – Case Study: Measurement System Analysis
2.18 MEASURE – Knowledge Check 1 (4 tasks)
2.20 MEASURE – Knowledge Check 2 (4 tasks)
2.19 MEASURE – Knowledge Check 3 (1 task)
2.21 MEASURE – Knowledge Check 4 (1 task)
2.22 MEASURE – Quiz
IASSC Lean Six Sigma Green Belt: ANALYSE PHASE
ANALYSE – Phase Intro
3.00 ANALYSE – Course Structure
3.01 ANALYSE – Overview
3.02 ANALYSE – Multi-vari Analysis
3.03 ANALYSE – Classes of Distributions
3.04 ANALYSE – Hypothesis Testing
3.05 ANALYSE – Sample Variance & Population Variance
3.06 ANALYSE – Continuous Output Data – Comparing Two Samples
3.07 ANALYSE – Continuous Output Data – Comparing More than Two Samples
3.08 ANALYSE – Continuous Output Data – Testing a Sample Against a Standard
3.11 ANALYSE – Phase Summary
3.12 ANALYSE – Case Study: The Box Plot
3.13 ANALYSE – Knowledge Check 1 (4 tasks)
3.15 ANALYSE – Knowledge Check 2 (4 tasks)
3.14 ANALYSE – Knowledge Check 3 (1 task)
3.16 ANALYSE – Knowledge Check 4 (1 task)
3.17 ANALYSE – Quiz
IASSC Lean Six Sigma Green Belt: IMPROVE PHASE
IMPROVE – Phase Intro
4.00 IMPROVE – Course Structure
4.01 IMPROVE – Regression Analysis
4.02 IMPROVE – Multiple Regression
4.03 IMPROVE – Design of Experiments
4.04 IMPROVE – Full and Fractional Factorials
4.05 IMPROVE – Concept Generation
4.06 IMPROVE – Implementation
4.07 IMPROVE – Phase Summary
4.08 IMPROVE – Case Study: Regression Analysis
4.09 IMPROVE – Knowledge Check 1 (4 tasks)
4.11 IMPROVE – Knowledge Check 2 (4 tasks)
4.10 IMPROVE – Knowledge Check 3 (1 task)
4.12 IMPROVE – Knowledge Check 4 (1 task)
4.13 IMPROVE – Quiz
IASSC Lean Six Sigma Green Belt: CONTROL PHASE
CONTROL – Phase Intro
5.00 CONTROL – Course Structure and Overview
5.01 CONTROL – Final Capability, Lean Controls
5.02 CONTROL – Control Plans
5.03 CONTROL – Center Line & Control Limit Calculation, Control Plans
5.04 CONTROL – Phase Summary
5.05 CONTROL – Case Study: The Control Plan
5.06 CONTROL – Knowledge Check 1 (4 tasks)
5.08 CONTROL – Knowledge Check 2 (4 tasks)
5.07 CONTROL – Knowledge Check 3 (1 task)
5.09 CONTROL – Knowledge Check 4 (1 task)
5.10 CONTROL – Quiz
IASSC Lean Six Sigma Green Belt: CONCLUSION
CONCLUSION
Six Sigma DMAIC Project Case Study
DMAIC Project Case Study: Reducing Shirt Defect Rates
Six Sigma DMAIC Simulation
DMAIC Simulation
IASSC Lean Six Sigma Exam Prep Webinars
IASSC Lean Six Sigma Exam Prep – DEFINE
IASSC Lean Six Sigma Exam Prep – MEASURE
IASSC Lean Six Sigma Exam Prep – ANALYSE
IASSC Lean Six Sigma Exam Prep – IMPROVE
IASSC Lean Six Sigma Exam Prep – CONTROL
IASSC Lean Six Sigma Green Belt: SAMPLE TEST PAPERS
Sample Test Paper 1 – Questions and Answers
Sample Test Paper 2 – Questions
Sample Test Paper 2 – Questions and Answers
Sample Test Paper 3 – Questions
Sample Test Paper 3 – Questions and Answers
Sample Test Paper 4 – Questions
Sample Test Paper 4 – Questions and Answers
Sample Test Paper 5 – Questions
Sample Test Paper 5 – Questions and Answers
Sample Test Paper 6 – Questions
Sample Test Paper 6 – Questions and Answers
RESOURCE: Six Sigma Exam Reference Document
IASSC Examination Reference Document
RESOURCE: Six Sigma DMAIC Excel Templates
DEFINE Templates
MEASURE Templates
ANALYSE Templates
IMPROVE Templates
CONTROL Templates
RESOURCE: Six Sigma Minitab Exercises
WEBINAR (with Tamela Serensits). TOPIC: Introduction to Minitab
Minitab Exercises – Series Intro
DEFINE Minitab Exercises
MEASURE Minitab Exercises
ANALYSE Minitab Exercises
IMPROVE Minitab Exercises
CONTROL Minitab Exercises
RESOURCE: Six Sigma Webinars
Six Sigma: How to Apply it in the Real World
Six Sigma: DMADV

IASSC lean six sigma green belt course. Online, 24/7 access to content and exam. Fee includes learning content, live webinars, tutor support, and official IASSC exam.

IASSC Lean Six Sigma Green Belt (Exam Included) – 12 Months Access

<p id="isPasted" style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">LOOKING FOR:</strong> ADULT FICTION</p><p id="isPasted" fr-original-style="">Steven is the agency assistant at Eve White, working closely with agents Eve and Ludo on their lists of clients. He grew up in Newcastle upon Tyne and moved to Paris after completing an MPhil in comparative film &amp; literature at Cambridge. He taught English and worked freelance for several literary scouting agencies before joining the agency in July 2021.</p><p fr-original-style="">Steven enjoys reading fiction and non-fiction of all kinds, but has a particular interest in non-fiction which sheds light on under-represented perspectives, communities and histories, and fiction which explores new ideas, challenges the reader, and plays with style, form, character and/or plot.&nbsp;</p><p fr-original-style="">Items on his wish lists might include:</p><p fr-original-style="">Fiction (Adult/YA) : historical fiction exploring contemporary issues through an unknown event and/or under-represented perspectives; an international thriller with an immediately recognisable hook; autofiction exploring contemporary socio-political issues; a moody detective series with a focus on human character; unique and innovative literary fiction; fun, accessible cosy crime with an original setting/protagonist.</p><p fr-original-style="">Fiction (MG) : fun, historical adventure exploring contemporary issues; a quirky detective/mystery series; a funny and warm-hearted family-/relationship-based drama with a strong voice.</p><p fr-original-style="">Non-fiction : memoir &amp; voice-driven narrative non-fiction.</p><p fr-original-style="">But, most of all, he just loves to be taken into a world and surprised by what he reads!</p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">Steven would like you to submit a short covering letter, 1 page synopsis and the first three chapters of your manuscript in a single word document.&nbsp;</strong></p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">(<em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">In addition to the paid sessions, Steven is kindly offering one free session for low income/under-represented writers. </em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">discretion of&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print)</em>.&nbsp;</p><p fr-original-style="">By booking you understand you need to conduct an internet connection test with<strong fr-original-style="">&nbsp;</strong><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Pr</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">int</em> prior to the event. You also agree to email your material in one document to reach <em fr-original-style="">I Am In Print</em> by the stated submission deadline and note that <em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print</em> take no responsibility for the advice received during your agent meeting.</p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">The submission deadline is: Friday 1 December 2023</strong></p>

LOOKING FOR: MG / YA / ADULT FICTION & NON-FICTION

Steven Evans is an Agent and the Company Manager at Eve White. He grew up in Newcastle upon Tyne and studied French & Italian at Queens’ College, Cambridge. After completing an MPhil in Comparative Film & Literature, Steven lived in Paris, where he worked as a university language assistant and a freelancer for various scouting agencies. He joined Eve White Literary Agency in 2021.

Steven reads fiction and non-fiction of all kinds. The non-fiction books he loves most often shed light on under-represented perspectives, communities and histories, while in fiction he seeks novels which might explore new ideas, challenge the reader or play with style, form, character and/or plot. Above all, he likes writing which has a sense of purpose, and likes to be taken by surprise.

Items on Steven's wish list might include:
Fiction (Adult) :
Crime/thriller – might be regional or with an unusual hook/high-concept. Might have a speculative element (think Stuart Turton). A spy thriller appeals. Cosy crime with an original setting/protagonist is also welcome.
Literary fiction – worlds, characters, perspectives and histories which haven’t been written about before. Might be formally or stylistically innovative (but with a sense of purpose that links back to the story/characters).
Historical fiction – themes and ideas relevant to our current moment are on the list. Might be revisionist.
Romance – contemporary: either very heartfelt, cosy, perhaps with older characters. Or, spicy, funny, tapping into current trends.
Horror – on the literary end, perhaps with a folk tale element.
Fiction (YA) :
Thrillers
Romance
Fiction (MG) :
Fun, historical adventure exploring contemporary issues. Might be tied into the national curriculum, though without being didactic.
Quirky detective/mystery series.
Funny and warm-hearted family-/relationship-based drama with a strong voice.
Non-fiction : Voice-driven narrative non-fiction ; memoir ; big ideas.

Most of all, Steven just loves to be taken into a world and surprised by what he reads!

Steven would like you to submit a short covering letter, 1 page synopsis and the first 5,000 words of your novel in a single Word document. 

(In addition to the paid sessions, Steven is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). 

By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.

The submission deadline is: Thursday 3rd July 2025

I Am In Print

SOLD OUT! 11th July Steven Evans #Agent121. Looking for: MG, YA, ADULT FICTION, NON-FICTION

London

<div>
	                  <h5>Excel Macros and VBA Course summary</h5>
	               </div>
	               <div></div>
	               <p> 
				   
				  For Excel users. Extend the capabilities of Excel with Macros and VBA code.
	              

				  </p>
				   
				   
	               <div>
	                  <div>
	                     <h5>Excel Macros and VBA Course Description</h5>
	                  </div>
	                  <div></div>
	                  <p> 
	                  
					  
					  
					  </p>
	                

	                		<br /><b>Create simple macros</b> using the macro recorder and run them from shortcuts or buttons on the ribbon

						<br />Setting Excel Macro Options
						<br />Record and Run Simple Macros
						<br />Assign Macros to the Quick Access Toolbar

					<br /><b>Introduction to the Excel VBA Editor</b>

					<br />Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules

						<br />Starting the Visual Basic Editor
						<br />Using the Project Explorer
						<br />Using the Properties Window
 

					<br /><b>Creating Procedures and Functions</b>

					<br /><b>Create simple macro procedures</b> in code that use variable to store data and communicate with the user

						<br />Creating Sub and Function Procedures
						<br />Declare and Use Variables
						<br />Displaying Message to the User
						<br />Getting Input from the User

					<br /><b>Controlling Program Flow</b>

					<br /><b>Using decision making and looping structures to control the way your program works</b>

						<br />Using the IF Statement
						<br />Using the Select Case Statement
						<br />Using For Next Loops
						<br />Using Do Loops
						<br />Using For Next Loops
			 

					<br /><b>Interacting with the spreadsheet :</b>

						<br />Referencing Cells and Ranges
						<br />Gathering Cell and Range Information
						<br />Using the Offset Method
						<br />Using With Blocks
						<br />Referencing Workbooks and Worksheets
						<br />Updating values in the spreadsheet 

					<br /><b>Functions</b>

						<br />Using standard Excel functions in VBA
						<br />Creating new custom functions
						<br />Calling functions and sub procedures

					<br /><b>User Forms</b>

						<br />Basic design and display
						<br />Getting information via forms and update cells
					

					<br /><b>Practical project and examples</b>
					<br /><br /> 
					
			 
			<h4>Other Excel Courses</h4>
			<br /><br />
 
 
 
 
	               </div>
	               <div id="cincluded">
	                  <div>
	                     <h5>What is included in the Excel VBA Courses:</h5>
	                  </div>
	                  <div>
	                     <ul>
	                        <li>Excel VBA Course Certificate on completion  </li>
	                        <li>Excel VBA Course notes</li>
	                        <li>Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work</li>
	                         
	                        <li>After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.</li>
	                        <li>Max group size, online and in classroom, on this Excel VBA Course is 4. </li>
	                     </ul>
	                  </div>
	               </div>

Excel Macros and VBA Course summary
 For Excel users. Extend the capabilities of Excel with Macros and VBA code. 
Excel Macros and VBA Course Description
Create a simple mile/km converter with a frontend, user-input for, click button to start and update a spreadsjeet 
What is included in the Excel VBA Courses:
Excel VBA Course Certificate on completion
Excel VBA Course notes
Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work
After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.
Max group size, online and in classroom, on this Excel VBA Course is 4.

PCWorkshops

Visual Basic

Access VBA

For Excel users. Extend the capabilities of Excel with Macros and VBA code. 

Excel Macros and VBA Course, 1-Hour Taster

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



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


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


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


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

This course has now started but you can still sign up to gain live access to our future sessions. Recordings will be made available at a later date exclusively for HA members.

Join us this summer to celebrate 250th anniversary of the birth of Jane Austen with this brand new webinar series from the Historical Association. We will explore the work and influence of the famous novelist to illuminate our understanding of the Georgian era and the society that Austen brought to life. Sessions include:

24 June - Domestic economies: families, home and work in the age of Jane Austen | Dr Sara Pennell
1 July - A Q and A with one of the world's leading experts on Jane Austen, Professor John Mullan
14 July - 'I am … MAD': The life in Jane Austen’s Letters | Dr Freya Johnston
22 July - The social spread of the handshake in the age of Jane Austen | Professor Penelope Corfield

All sessions take place from 5-6.30pm and will be hosted online via Zoom. Once you have signed up your details will be registered for all sessions and you will receive joining instructions directly from Zoom. If you have any questions feel free to contact us at shortcourses@history.org.uk. 

On the day of the session joining links will be sent out up until 1pm on the day of the session.

All images public domain, central image of Jane Austen modified by Wikimedia user Amano1.

Historical Association

HA Webinar series: Jane Austen and Georgian England

<p id="isPasted" style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">LOOKING FOR</strong>: ADULT FICTION, NON-FICTION</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Diana joined the prestigious DHH Literary Agency in June 2024. She started agenting with Rupert Heath Literary Agency in 2011 before moving to UTA and Marjacq in 2017. Before that she was senior commissioning editor at Transworld. <span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Diana was </span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">chosen as one of The Bookseller&rsquo;s Rising Stars of 2012, was a nominee for RNA Agent of the Year 2019, and was shortlisted for Literary Agent of the Year 2022 at the British Book Awards.&nbsp;</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Her list includes a wide range of bestselling and prize-winning authors in the UK and internationally.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Diana represents adult fiction and non-fiction. For fiction, she is looking for upmarket women&#39;s commercial, with depth and heart, including reading group, historical, saga, uplit and contemporary stories that are irreverent and make her laugh; accessible literary fiction, high-concept crime fiction and thrillers.<span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">She has a thing for spy novels and would love to find a great vampire story.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">On the non-fiction side: memoir, smart, funny feminists, lifestyle, cookery and social justice, and open to anything with a strong, original voice. She also encourages submissions from writers who have been traditionally under-represented.</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;">Diana would like you to submit a covering letter, 1 - 2 page synopsis and the first three chapters (a maximum of 5,000 words) of your manuscript in a single word document.&nbsp;</strong></p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">(<em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">In addition to the paid sessions, Diana is kindly offering one free session for low income/underrepresented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the discretion of </em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print)</em>.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By booking you understand you need to conduct an internet connection test with<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> </strong><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Pr</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">int</em> prior to the event. You also agree to email your material in one document to reach <em fr-original-style="" style="box-sizing: border-box;">I Am In Print</em> by the stated submission deadline and note that <em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print</em> take no responsibility for the advice received during your agent meeting.</p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">The submission deadline is: Wednesday 4 September 2024</strong></p>

LOOKING FOR: ADULT FICTION

Marilia Savvides founded The Plot Agency in 2024. She began her career in publishing at Peters Fraser and Dunlop, where she spent eight years, first as International Rights Agent, and later as Literary Agent, building her own list of authors. In 2019, she joined 42MP, where she worked as Literary Agent for four years, helping to launch and set up the Book Division.

She is particularly interested in fiction that is beautifully written and cleverly constructed, but still accessible to a wide readership. She is often drawn to darker tales that weave together excellent characters and an impossible-to-put-down story, from immersive book club novels with a splash of suspense, crime and thrillers, accessible horror, and speculative, genre-bending or dystopian stories. She also adores smart, witty contemporary rom-com in the style of Emily Henry.

In the thriller, crime and mystery space she is interested in most areas, except military thrillers and organised crime/ mafia / mob stories. Big hooks and clever set ups are a big bonus! She adores Karin Slaughter (especially her standalone novels) and Gillian Flynn.
In the book club / reading group space, she’s particularly drawn to fiction in the vein of Jodi Picoult, Liane Moriarty and Celeste Ng, and absolutely fell in love with Bright Young Women by Jessica Knoll, both for the incredible voice, and the exquisite use of structure and time. Complicated family dynamics, empathetic and smart approaches to controversial issues, stand out protagonists (like Elizabeth Zott in Lessons in Chemistry or Bernadette in Where D’You Go Bernadette), long buried secrets, complicity, the road to justice, and impossible decisions, are all themes she finds herself drawn to.
In the horror space, she’s a sucker for amazing female-centric stories in the vein of Yellowjackets, and the kind of contemporary, accessible horror that Stephen King always nails. She wants to get lost in a world that feels within reach of ours. In the speculative and dystopian spaces, she’s interested in genius ideas that set up big questions or reflect the most broken (and sometimes hidden) parts of society. She loves Octavia Butler, Margaret Atwood, George Orwell, and also adored The Leftovers, Station Eleven, Wanderers, and The Power. The what-ifs of life and fiction fascinate her. In the grounded sci-fi space, she’d love to find a smart, immersive, and accessible story like The Martian.
She doesn’t represent fantasy or romantasy. In regards to sci-fi, unless it’s very grounded and has crossover potential to a mainstream audience, it’s not for her.
In the romance space, she’s particularly drawn to smart, complex and witty characters, where the chemistry is jumping off the page. She loves contemporary settings and all the tropes, though the voice and characters must come first to make the reading experience fully immersive. She wants to be cackling, and rooting for the characters with all her heart.

She is very hands-on editorially, and loves working with her authors to shape their manuscripts, and brainstorm ideas. The best part of the job is discovering debut authors, and helping them find a home for their books.

Marilia would like you to submit a covering letter, 1 - 2 page synopsis and the first 5,000 words of your manuscript in a single Word document. 

(In addition to the paid sessions, Marilia is kindly offering one free session for low income/underrepresented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). 

By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.

The submission deadline is: Tuesday 8th July 2025

Fiction Writing

BOOKINGS CLOSED! 15th July Marilia Savvides #Agent121. Looking for: ADULT FICTION

This one hour evening workshop will help you to start the process of thinking about what you want to do (e.g: major repairs, improved access, reordering to create flexible space, installing toilets or a kitchenette) and the initial steps to take towards developing it into a viable project. We'll also look at the different types of funders you might want to consider applying to for a grant. Please note numbers are limited to allow everyone a chance to tak and share their ideas.

The Diocese of St Albans

Developing your project and funding it.

<p id="isPasted" style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">LOOKING FOR:</strong> ADULT FICTION</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Kate Barker has worked in publishing for over twenty years as an agent, commissioning editor and ghostwriter. Before setting up her own company, Kate Barker Literary Agency, she spent ten years at Penguin, where she was an Editorial Director for Viking, acquiring fiction and non-fiction. She has also worked for Orion, Curtis Brown and for digital publisher Bookouture.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">She is looking for commercial and reading group fiction for adults and would love to find an unputdownable thriller like Rosamund Lupton&#39;s <em fr-original-style="" style="box-sizing: border-box;">Three Hours</em>, a funny, heartbreaking contemporary novel like <em fr-original-style="" style="box-sizing: border-box;">Queenie</em> by Candice Carty-Williams or a romantic comedy with a unique premise like <em fr-original-style="" style="box-sizing: border-box;">The Flatshare</em> by Beth O&#39;Leary. She also loves historical fiction and series crime.</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;">Kate would like you to submit a covering letter, one page synopsis and the first three chapters (Max 5,000 words) of your completed manuscript in a single word document.</strong></p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">(<em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">In addition to the paid sessions, Kate is kindly offering one free session for low income/under-represented writers. </em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">discretion of&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print)</em>.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By booking you understand you need to conduct an internet connection test with<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Pr</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">int</em> prior to the event. You also agree to email your material in one document to reach <em fr-original-style="" style="box-sizing: border-box;">I Am In Print</em> by the stated submission deadline and note that <em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print</em> take no responsibility for the advice received during your agent meeting.</p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">The submission deadline is: Monday 23 September 2024</strong></p>

LOOKING FOR: ADULT FICTION, SCIENCE FICTION / FANTASY

After several years spent within publishing houses Bookouture, Canelo, Avon, One More Chapter and Head of Zeus, Hannah Todd became a Literary Agent at the Madeleine Milburn Literary, TV & Film Agency, before joining Janklow & Nesbit in January 2025. Her clients include Kirsty Greenwood, Charlie Gallagher and Leah Mercer.

Hannah is keen to see commercial fiction across the board, but with a particular focus on romance, Science Fiction/Fantasy & mystery novels. She is drawn to books with exemplary characterisation, voice and strength of feeling. But don't let your characterisation overshadow the need for impeccable plot and if you can make her laugh or cry then you're onto a winner! 

Across the full light-dark spectrum Hannah especially loves SFF that features an unlikely band of heroes, like the Six of Crows series by Leigh Bardugo, Scott Lynch's Gentleman Bastard series, Becky Chambers' The Long Way to a Small Angry Planet, T. Kingfisher's Nettle and Bone,and  the cosy themes/settings offered by Heather Fawcett and TJ Klune.

Hannah's advice is make sure you have a clear USP and hook: If you are sending your reader to a magical academy, or if we're riding dragons or waving wands, that's great! But what makes your book feel different and fresh? An excellent voice is key, but what else makes your take on these tropes stand out? An example of a phenomenal book that has turned the magical academy trope on its head, with layers of excellent world building, a unique magic system and plot twists galore is The Will of the Many by James Islington. If you have something crafted this beautifully then Hannah wants to see it!

Romantasy of varying spice levels, accessible to both romance and fantasy readers, is on Hannah's wishlist. And you can whisk her away with contemporary romance novels, romcoms, sweeping love stories that redefine the genre. Romcoms with great disability rep and LGBTQIA+ stories that focus on the joy of falling in love are high on Hannah's agenda. She particularly loves Emily Henry, Laura Wood and Abby Jiminez. Think more Nicholas Sparks than Sally Rooney, and Bonnie Garmus rather than Gabrielle Zevin. In this space, she is a big fan of Emma Donoghue, Bonnie Garmus and Jojo Moyes.

Meet with Hannah to discuss your crime and high-concept thrillers with an unsettling ‘it-could-happen-to-me’ feeling, coupled with a twist that's unseen until its delivery. The book she most wants to find in this space is something like Three Hours by Rosamund Lupton in both its themes (real-world emotional suspense) and its execution. A mystery series that feels like a real 'romp' is something she loves to escape with too. 

With regards to all genres, Hannah is particularly interested in voices from underrepresented backgrounds: such as writers of colour, indigenous communities, the LGBTQIA+ community, and those with disabilities.

Hannah does not the right agent to give advice on:
Re-imaginings of the classics
Books that feature characters putting on Shakespeare plays!
Historical fiction
Children's, middle-grade and YA 

Hannah would like you to submit a covering letter, one page synopsis and the first 5,000 words of your completed manuscript in a single word document.

(In addition to the paid sessions, Hannah is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). 

By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.

The submission deadline is: Tuesday 8th July 2025

BOOKINGS CLOSED! 16th July Hannah Todd #Agent121. Looking for: ADULT FICTION

<p id="isPasted" 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 id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Residual models (profit &amp; site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course.</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;">On this course you will&hellip;</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to calculate land and profit residuals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions</li><li value="3" fr-original-style="" style="box-sizing: border-box;">You will be taught how to find maximum bidding prices for site development and building refurbishments</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Understanding development financing considerations and learn how to optimise financing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse financial and project completion risks</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Developers</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Fund managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Land managers</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Planning managers</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Lenders</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;">Course Outline</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;">Day One</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;">Learn how to build a discounted cash flow, analyse returns and understand the components of development models</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Gross versus Net Yields, calculating Net Development Value (NDV)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Profit residual, with and without financing</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Site residual, how to calculate profit without knowing your costs.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introducing financing to site residual calculations</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Purchase price and acquisition costs</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Phased Sales, marketing and disposal costs</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Professional fees</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Income and expenditure project functions</li><li value="10" fr-original-style="" style="box-sizing: border-box;">Logic functions, logic tables and array formulae</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;">Day Two</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;">Learn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Multiple IRRs, competing projects, scoping and linear programming, maximising performance</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Return metrics: Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Alternative site calculation, Net present value (NPV),</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling construction costs using S-curve , variable costs, incidental costs and construction fees</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Switching between scenarios</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Introduction to Development financing, Pari Passu versus Equity First Financing</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Debt scheduling: brought forward and carried forward method</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Consideration of the impact of development finance interest, fees and covenants</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;">Included in the Course</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Developer such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.
This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.
Residual models (profit & site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.
Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.
The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course.


On this course you will…
Learn how to calculate land and profit residuals
Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions
You will be taught how to find maximum bidding prices for site development and building refurbishments
Understanding development financing considerations and learn how to optimise financing
Analyse financial and project completion risks
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Developers
Surveyors
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Fund managers
Asset managers
Land managers
Planning managers
Lenders


Course Outline
Day One
Learn how to build a discounted cash flow, analyse returns and understand the components of development models
Gross versus Net Yields, calculating Net Development Value (NDV)
Profit residual, with and without financing
Site residual, how to calculate profit without knowing your costs.
Introducing financing to site residual calculations
Purchase price and acquisition costs
Phased Sales, marketing and disposal costs
Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees
Professional fees
Income and expenditure project functions
Logic functions, logic tables and array formulae


Day Two
Learn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects
Multiple IRRs, competing projects, scoping and linear programming, maximising performance
Return metrics: Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)
Alternative site calculation, Net present value (NPV),
Modelling construction costs using S-curve , variable costs, incidental costs and construction fees
Switching between scenarios
Introduction to Development financing, Pari Passu versus Equity First Financing
Debt scheduling: brought forward and carried forward method
Consideration of the impact of development finance interest, fees and covenants


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


For more information about the Real Estate Developer 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

Real Estate Finance

Financial Risk Management

This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.

Real Estate Developer (Development Cash Flow Modelling in Excel)

<p id="isPasted" style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">LOOKING FOR:</strong>&nbsp;PICTURE BOOKS, CHAPTER BOOKS, MG, YA, CHILDREN&#39;S NON-FICTION</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">After a childhood buried in library books and Beanos, Lydia started her career in the editorial team at Egmont, where she commissioned books such as the Carnegie Medal-winning The Poet X. She joined the Darley Anderson team in 2018, and as well as building an engaging and diverse list of authors and illustrators, she was promoted to Director in March 2024. With experience on both sides of the commissioning desk, Lydia loves working editorially with her clients and developing ideas from an initial spark into a full manuscript. She represents clients across all age groups, including picture book, chapter book, middle grade and YA, and has a particular focus on non-fiction. Lydia reads and considers widely, and among other things she is looking for snort-inducing stories for younger readers, clever and contemporary teenage and YA fiction, and non-fiction projects that take big ideas and make them easily navigable, accessible and fun. No matter the story, Lydia is drawn to voice above anything else and will always be sucked in by a strong hook.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Lydia represents clients including Soofiya, Gina Blaxill, Mark Bradley, Ryan Hammond, Alice Harman, Joyce Efia Harmer, Catherine Jacob, Hannah Moffatt, Rachel Morrisroe, Nick Sheridan, Rashmi Sirdeshpande and Eva Wong Nava. If you could sum up her tastes in three words, they would be curious, characterful and heartfelt, and in three books, they would be One of Us is Lying, Nevermoor and You Are Awesome.</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;">Lydia would like you to submit a covering letter, a 1 page synopsis and the first 3 chapters or 20 pages of your completed manuscript in a single word document. For Picture Books please submit a covering letter and texts for two completed stories.</strong></p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">(<em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">In addition to the paid sessions, Lydia is kindly offering one free session for low income/under-represented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the </em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">discretion of&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print)</em>.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By booking you understand you need to conduct an internet connection test with<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Pr</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">int</em> prior to the event. You also agree to email your material in one document to reach <em fr-original-style="" style="box-sizing: border-box;">I Am In Print</em> by the stated submission deadline and note that <em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print</em> take no responsibility for the advice received during your agent meeting.</p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">The submission deadline is: Monday 29 April 2024</strong></p>

LOOKING FOR: PICTURE BOOKS, CHAPTER BOOKS, MG, YA, CHILDREN'S NON-FICTION

After a childhood buried in library books and Beanos, Lydia started her career in the editorial team at Egmont, where she commissioned books such as the Carnegie Medal-winning The Poet X. She joined the Darley Anderson team in 2018, and as well as building an engaging and diverse list of authors and illustrators, she was promoted to Director in March 2024. With experience on both sides of the commissioning desk, Lydia loves working editorially with her clients and developing ideas from an initial spark into a full manuscript. She represents clients across all age groups, including picture book, chapter book, middle grade and YA, and has a particular focus on non-fiction. Lydia reads and considers widely, and among other things she is looking for snort-inducing stories for younger readers, clever and contemporary teenage and YA fiction, and non-fiction projects that take big ideas and make them easily navigable, accessible and fun. No matter the story, Lydia is drawn to voice above anything else and will always be sucked in by a strong hook.

Lydia represents clients including Soofiya, Gina Blaxill, Mark Bradley, Ryan Hammond, Alice Harman, Joyce Efia Harmer, Catherine Jacob, Hannah Moffatt, Rachel Morrisroe, Nick Sheridan, Rashmi Sirdeshpande and Eva Wong Nava. If you could sum up her tastes in three words, they would be curious, characterful and heartfelt, and in three books, they would be One of Us is Lying, Nevermoor and You Are Awesome.

Lydia would like you to submit a covering letter, a 1 page synopsis and the first 3 chapters or 20 pages of your completed manuscript in a single word document. For Picture Books please submit a covering letter and texts for two completed stories.

(In addition to the paid sessions, Lydia is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). 

By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.

The submission deadline is: Monday 7th July by 12noon UK BST

BOOKINGS CLOSED! 16th July Lydia Silver #Agent121. Looking for: PICTURE BOOKS, CHAPTER BOOKS, MG, YA, CHILDREN'S NON-FICTION

Hosted by Let's Do Business Finance
 Date: 16th July
 Time: 12pm – 12.45 pm 
Location: Online (Zoom link provided upon registration)
 Cost: Free

Is your business finding it hard to access finance through traditional lenders?
 You’re not alone — and there is another way.

Join us for this free lunchtime webinar to discover how the Community Enable Fund from British Business Bank can help you access the funding you need to grow, even if you’ve previously struggled to secure finance.

We’ll be joined by a panel of industry experts:
Lisa Young – Let’s Do Business Finance (the first accredited lender on the scheme)
Susan Elliott – British Business Bank
Matt Woodcock – Responsible Finance

What You’ll Learn:
What the Community Enable Fund is and how it works
Why it was created and how it can help your business
Real examples of how the fund can help SMEs
How to apply and what to expect during the process
Support available alongside the funding

Whether you're a growing business, or simply exploring new finance options, this session is for you.

💬 There will be a live Q&A with our panel, so bring your questions!

Who should attend?
SME business owners and directors
Community-focused and purpose-led businesses
Anyone who has previously struggled to secure business finance
 

Reserve your place today and take the next step towards unlocking funding for your business.

35880 Courses in Cardiff delivered Online

E-Learning English - Academic English - Self Access Course

By ELHUK

Microsoft Office Skills (MS Excel, Word, PowerPoint, Access), Administration & IT Training

By Skill Up

IASSC Lean Six Sigma Black Belt (Exam Included) – 12 Months Access

By Hudson

E-Learning English - General English B1 - Self Access Course

By ELHUK

E-Learning English - General English C1 - Self Access Course

By ELHUK

E-Learning English - General English B2 - Self Access Course

By ELHUK

E-Learning English - General English A1 - Self Access Course

By ELHUK

E-Learning English - General English A2 - Self Access Course

By ELHUK

Level 2 Microsoft Office Essentials

By Apex Learning

IASSC Lean Six Sigma Green Belt (Exam Included) – 12 Months Access

By Hudson