Name: Mandatory Refresher Training
Price: 77 GBP
Availability: InStock
Rating: 4.8125 (48 reviews)

Maidstone

<h1 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Overview:</h1>This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.Course Contents:Having an effective team around you is crucial. However, it is an area that is often left to chance, which can lead to de-motivated individuals that do not feel part of the business and consequently do not perform. This course looks at what it takes to lead an effective team and how you can get the best out of the people in it by understanding the role of the leader, both personally and from the point of view of the team.Course Topics:<ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Qualities of an Effective Leader&nbsp;&ndash; Identifying the key characteristics of effective leaders, rating themselves against them and establishing key actions to develop the skills.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Leader or Manager?&nbsp;&ndash; Establishing the difference between the two and comparing themselves to those qualities.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">That Vision Thing&nbsp;&ndash; Making the business vision &lsquo;live&rsquo; for the team by answering key questions.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Developing Your Team Goals&nbsp;&ndash; Reviewing an action plan that develops clear goals for their team based on the business vision.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivation&nbsp;&ndash; Determining the &lsquo;Why&rsquo; for their staff and developing an understanding of emotions in a business context.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">What Motivates?&nbsp;&ndash; Looking at specific motivators for individuals and understanding that everyone is motivated by different things.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Being Consistently Different&nbsp;&ndash; Going against popular leadership theory and identifying that each staff member needs to be treated differently.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Dealing With Difficult Team Members&nbsp;&ndash; Understanding why team members are difficult. Looking at different behavior types and strategies for responding to them. Also, realizing that &lsquo;difficult&rsquo; behavior sometimes has its benefits.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coaching&nbsp;&ndash; Using a simple method of coaching, including action plans.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Three Key Skills of Coaching&nbsp;&ndash; Looking at the skills required to be an effective coach.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Instant Results Coaching&nbsp;&ndash; Coaching in a hurry!</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Can Do Coaching Practice&nbsp;&ndash; Putting the learning into practice</li></ul>Course Feature:By the end of this training you will be able to:<ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the qualities of an effective leader</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Benchmark themselves against those qualities and develop actions to improve</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the difference between leading and managing</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the value of sharing the business vision with the team</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Develop team goals based on the business vision</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivate their staff by understanding their drivers and developing actions to support them</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Deal with difficult staff members</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Challenge staff in a meaningful and effective way</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coach staff effectively using a simple process</li></ul>Certification:Once after the training you receive course completion certificate from MangatesWho can Attend?Anybody who is interested in learning Effective Skills to Lead a Team.

Certificate: Course Completion Certificate | Language: English

Duration: 2 Days | Credits: 16 PDUs

Course Delivery: Classroom | Virtual Live

Lunch and Beverages are included in a classroom session

Course Description:

In the competitive construction industry, the need for training is more vital than ever. Organizations that devote resources to professional development are more likely to see higher productivity and greater efficiency. On-the-job training can provide crucial knowledge to perform tasks at hand, but the best professionals constantly seek to learn about new techniques and technologies to improve their performance on-site and in the office.

Our Construction Project Manager Course (PMC) provides project managers the chance to sharpen the skills necessary to work more efficiently, increase productivity, and propel your construction business to the next level. PMC provides the ideal opportunity for project managers to gain crucial knowledge and leadership skills to stay competitive. This program will provide participants with skills they can immediately implement on the job and in the field. Everyone who goes through the program has something to gain over an intense week of workshops, assignments, and team-building activities.

PMC participants experience an interactive program that explores 15 critical areas of project management that seasoned project managers tackle on a daily basis. PMC provides participants with practical solutions to current industry challenges they can take back to immediately impact performance and improve project results.

Learning Objectives: 

Upon successful completion of this course, the learner will be able to:

● Identify the importance of pre-planning and its correlation with a company’s bottom line.
● Discuss the impact of low job site productivity on the project contractor, craftsperson, project owner, and designer.
● Discuss information required to evaluate and select subcontractor and vendor services and material and equipment purchases.
● Identify legal actions, or lack thereof, that can have far-reaching legal consequences for the project manager, their company, and many others.

Course Topics:

Day 1:

1.Project Planning
Importance of pre-planning.
Developing comprehensive project plans.
Correlation between planning and profitability.
Tools and techniques for effective planning.

2.Safety Management
Importance of safety in construction.
Developing and implementing safety plans.
OSHA regulations and compliance.
Risk assessment and mitigation.

3.Construction Productivity
Factors affecting job site productivity.
Techniques to improve productivity.
Measuring and tracking productivity.
Case studies of productivity improvements.

4.Subcontractor & Vendor Management
Evaluating and selecting subcontractors and vendors.
Contract negotiation and management.
Performance monitoring and quality control.
Building and maintaining strong relationships.

5.Critical Path Method (CPM) Scheduling
Basics of CPM scheduling.
Developing and maintaining project schedules.
Identifying and managing critical paths.
Tools and software for scheduling.

Day 2:

1.Claims Management
Types of claims in construction.
Preventing and managing claims.
Documentation and communication strategies.
Dispute resolution methods.

2.Legal Issues & Contract Clauses
Key legal concepts in construction.
Important contract clauses and their implications.
Managing legal risks and liabilities.
Case studies of legal issues in construction.

3.Cost Control
Budgeting and cost estimation.
Tracking and controlling project costs.
Analyzing cost performance.
Techniques for cost reduction.

4.Project Recordkeeping
Importance of accurate recordkeeping.
Types of project records and documentation.
Best practices for maintaining records.
Tools for efficient recordkeeping.

5.Communication
Importance of effective communication.
Strategies for improving communication.
Tools and technologies for communication.
Case studies of communication failures and successes.

6.Time Management
Techniques for effective time management.
Prioritizing tasks and managing deadlines.
Tools for time tracking and management.
Case studies of time management in construction.

7.Problem Solving & Decision Making
Techniques for problem-solving.
Decision-making frameworks.
Analyzing and evaluating options.
Case studies of problem-solving in construction.

8.Innovation
Importance of innovation in construction.
Identifying and implementing new technologies.
Encouraging a culture of innovation.
Case studies of successful innovation.

Conclusion: 

The PMC course aims to equip project managers with the skills and knowledge necessary to excel in the construction industry. By addressing the critical areas of project management, participants will leave the course with practical strategies and tools to enhance their performance and drive their projects to success.
Who Can Attend?
The Construction Project Manager (PMC) 2 Days Training course is designed for:

Project Managers: Experienced project managers looking to enhance their skills and stay updated with the latest industry practices and technologies.
Construction Managers: Individuals responsible for overseeing construction projects who want to improve their management techniques and project outcomes.
Site Supervisors: Supervisors and foremen seeking to gain a deeper understanding of project management principles and practices to better support project managers.
Engineers and Architects: Professionals involved in the planning, design, and execution of construction projects who want to enhance their project management knowledge and skills.
Construction Professionals: Anyone in the construction industry, including estimators, planners, and coordinators, aiming to improve their project management capabilities and advance their careers.
Business Owners and Executives: Owners and executives of construction companies who want to ensure their project managers and teams are well-equipped with the necessary skills to drive project success and business growth.
Aspiring Project Managers: Individuals aspiring to move into project management roles within the construction industry, seeking foundational knowledge and skills to prepare for the transition.
HR and Training Managers: Human resource and training managers responsible for the professional development of their company's construction management teams.
Prerequisites
While there are no strict prerequisites for attending the PMC course, having a basic understanding of construction processes and some experience in construction project management will be beneficial. Participants should come prepared to engage in interactive discussions and practical exercises that require critical thinking and problem-solving skills.
Benefits of Taking the Construction Project Manager (PMC) 2 Days Training Course In-House
1. Customization to Your Needs:
● The course can be tailored to address the specific challenges and requirements of your organization, ensuring the content is relevant and directly applicable to your projects and team dynamics.

2. Convenience and Flexibility:
● Conducting the training in-house eliminates the need for travel, saving time and reducing costs for your employees. It also allows for scheduling flexibility to fit the course around your team's availability.

3. Team Building and Collaboration:
● In-house training fosters a collaborative learning environment, encouraging team building and improved communication among your employees. It provides an opportunity for your team to work together on practical exercises and case studies, strengthening their ability to collaborate effectively on future projects.

4. Immediate Application:
● The skills and knowledge gained during the course can be immediately applied to your current projects, leading to quick improvements in productivity, efficiency, and project outcomes.

5. Cost-Effective:
● In-house training is often more cost-effective than sending multiple employees to external courses. You save on travel and accommodation expenses, and there are often discounts available for group bookings.

6. Consistent Training:
● Ensuring that all relevant team members receive the same high-quality training ensures consistency in the application of project management principles and practices across your organization.

7. Confidentiality:
● In-house training allows your team to discuss sensitive and proprietary information freely without concerns about confidentiality. This can lead to more open discussions and practical problem-solving sessions.

8. Enhanced Engagement:
● Training conducted in a familiar environment can increase engagement and participation. Employees may feel more comfortable and willing to engage in discussions, ask questions, and participate in activities.

9. Long-Term Benefits:
● Investing in in-house training demonstrates your commitment to employee development, which can boost morale, job satisfaction, and retention rates. Employees are more likely to stay with an organization that invests in their professional growth.

10. Direct Access to Trainers:
● Having trainers on-site allows for more personalized interaction, immediate feedback, and the opportunity to address specific concerns or questions that arise during the training.

11. Aligns with Organizational Goals:
● In-house training can be aligned with your organizational goals and strategies, ensuring that the skills and knowledge gained are directly contributing to your company's overall objectives.

12. Follow-Up Support:
● Trainers can offer follow-up support and coaching to ensure that the concepts and techniques learned during the course are successfully implemented in your organization.

13. Increased Productivity:
● With the entire team trained together, there is a reduced learning curve, leading to quicker implementation of new practices and increased productivity.

14. Industry-Relevant Case Studies:
● Trainers can incorporate industry-relevant case studies and examples specific to your organization, making the learning experience more relatable and impactful.

By choosing to conduct the PMC 2 Days Training course in-house, your organization can maximize the benefits of professional development, ensuring that your team is equipped with the essential skills and knowledge to excel in the competitive construction industry.

Mangates

Construction Management

Project Manager

Construction Project Manager 2 Days Training in Maidstone

The sale ends 10 days before the event starts.

Early Bird Fee

The sale ends 5 days before the event starts.

Standard Fee

York

Construction Project Manager 2 Days Training in York

Leeds

Construction Project Manager 2 Days Training in Leeds

Plymouth

Construction Project Manager 2 Days Training in Plymouth

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



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


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


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


Day One:


Conventional Valuations
Term & Reversion
Layer Method
Over Rented
Equivalent Yield


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


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


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


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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Financial Analysis

Financial Management

Financial Risk Management

Professional Development

Continuous Professional Development (CPD)

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

An Introduction to Real Estate in Excel (Financial Modelling)

General Admission

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 &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.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&hellip;<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> Who will benefit from this course?<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> Course OutlineDay OneLearn how to build a discounted cash flow, analyse returns and understand the components of development models<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> Day TwoLearn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects<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> Included in the Course<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> 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.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



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

Microsoft Excel

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)

Birmingham

Bolton

Bradford

Bristol

Cambridge

Coventry

Derby

Gloucester

Hertford

High Wycombe

Huddersfield

Hull

Leicester

Liverpool

London

Luton

Manchester

Melton Mowbray

Middlesbrough

Milton Keynes

Northampton

Norwich

Nottingham

Oxford

Peterborough

Reading

Sheffield

Slough

Solihull

Stoke-on-Trent

Swindon

Telford

Warrington

Watford

Wolverhampton

Worksop

Our regionally-based associate Microsoft Excel trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.Course Outlines<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_training_course_in_leeds.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Beginners - 1 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_training_course_birmingham_excel_training_coventry.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Intermediate - 1-2 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_training_course_aylesbury_excel_training_milton_keynes.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Advanced - 1 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_training_masterclass_course.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Masterclass&nbsp;- 3 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/excel_power_query_training_course.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Excel Power Query - 1 day course</a> </li></ul>Pricing&pound;450.00 plus VAT per day and mileage for up to 3 learners. Just add &pound;50.00 plus VAT per additional learner up to the 10 delegate maximum.

Our regionally-based associate Microsoft Excel trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.
Course Outlines
Excel Beginners - 1 day course
Excel Intermediate - 1-2 day course
Excel Advanced - 1 day course
Excel Masterclass - 3 day course
Excel Power Query - 1 day course
Pricing
£450.00 plus VAT per day and mileage for up to 3 learners. Just add £50.00 plus VAT per additional learner up to the 10 delegate maximum.

FourSquare Innovations Ltd

Office Skills & Productivity

Office Skills

Spreadsheet

FourSquare Training specialise in private, corporate Microsoft Excel courses delivered at your premises and tailored to your needs.

Microsoft Excel Training

Learn the foundations of Excel that never get taught to you, this will catapult your confidence when working with Excel and give you a strong base when taking on other advanced topics. &nbsp;This course will teach you a methodology for working with Excel that exposes how the Excel application works.&nbsp;The course highlights many shortcuts, tips, and tricks to make you more productive on the job. It is said that more than 80% of Excel users are aware of only 20% of what Excel can do. We will show you the tools, functions, and techniques that will unlock the 80% of Excel you may not know about.&nbsp;This instructor-led course includes:&nbsp;&bull; &nbsp; &nbsp;2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions begin&nbsp;&bull; &nbsp; &nbsp;4 instructor-led virtual sessions of 2 hours each. Each Session will have a 15-minute break.&nbsp;&bull; &nbsp; &nbsp;Intersession Assignments that you are expected to complete and discuss in your preassigned groups during the session.&nbsp;&bull; &nbsp; &nbsp;1 Capstone Project&nbsp;&bull; Lifetime access to our LMS where you will have free access to the trainer, other participants, and resources including knowledge videos.&nbsp;&bull; &nbsp; &nbsp;Access to our community of life-long learners.&nbsp;&bull; &nbsp; &nbsp;Downloadable Certificate you can link to your LinkedIn page.We look forward to seeing you in Class!!!

Learn the foundations of Excel that never get taught to you, this will catapult your confidence when working with Excel and give you a strong base when taking on other advanced topics. This course will teach you a methodology for working with Excel that exposes how the Excel application works. 
The course highlights many shortcuts, tips, and tricks to make you more productive on the job. It is said that more than 80% of Excel users are aware of only 20% of what Excel can do. We will show you the tools, functions, and techniques that will unlock the 80% of Excel you may not know about.
 This instructor-led course includes: 
• 2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions begin 
• 4 instructor-led virtual sessions of 2 hours each. Each Session will have a 15-minute break. 
• Intersession Assignments that you are expected to complete and discuss in your preassigned groups during the session. 
• 1 Capstone Project 
• Lifetime access to our LMS where you will have free access to the trainer, other participants, and resources including knowledge videos. 
• Access to our community of life-long learners. 
• Downloadable Certificate you can link to your LinkedIn page.
We look forward to seeing you in Class!!!

dbrownconsulting

Excel Analytics

Master Excel to catapult your productivity skills with this online course. Go from Beginner to Pro in Excel

Power Excel 1 (the essentials)

This course will bring everyday Excel skills up a level to enhance your performance and improve your efficiency. What&#39;s not to like? No more Google searching for the correct shortcut!<ul style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><li style="color: rgb(80, 54, 89); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(80, 54, 89);">Entering text, numbers and Autofill</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Navigating Excel</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Selecting and editing</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Using the Sum function</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Basic formulae</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Rows, columns and borders</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Freezing panes</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Printing from Excel</li><li style="color: rgb(80, 54, 89); box-sizing: border-box;" fr-original-style=" color: rgb(80, 54, 89);">Custom use</li></ul> 2 weeks - 2 sessions a week (2hrs live online)<ul type="disc" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">25 June , 27 June , 2 July and 4 July</li></ul>Tuesdays &amp; Thursdays 09:30 - 11:30&pound;275+VAT per person<h2 style="color: rgb(35, 73, 109); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 73, 109);">This course is also available as in-house training at a fixed cost for up to 8 delegates.&nbsp;Email us for more information. <a href="mailto:admin@sterlingtraining.org" fr-original-style="" style="-webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">admin@sterlingtraining.org</a>.uk</h2>

This course will bring everyday Excel skills up a level to enhance your performance and improve your efficiency. What's not to like? No more Google searching for the correct shortcut!
Entering text, numbers and Autofill
Navigating Excel
Selecting and editing
Using the Sum function
Basic formulae
Rows, columns and borders
Freezing panes
Printing from Excel
Custom use


2 weeks - 2 sessions a week (2hrs live online)
25 June , 27 June , 2 July and 4 July
Tuesdays & Thursdays 09:30 - 11:30
£275+VAT per person
This course is also available as in-house training at a fixed cost for up to 8 delegates. Email us for more information. admin@sterlingtraining.org.uk

Sterling Training

Performance and efficiency-enhancing Excel skills for everyday users.

Mastering Excel

Course Description:Join us, agency nurses and HCAs, in our annual update course designed to ensure you remain current and competent. We offer a welcoming and comfortable learning environment to empower you with essential knowledge.&nbsp;Overview:Stay up-to-date as agency nurses and HCAs. Our course provides a friendly and comfortable space for learning and growth, ensuring you&#39;re well-prepared for your role.Key Learning Objectives:Explore vital topics including:Health &amp; Safety, PPECovid ManagementCOSHH &amp; RIDDOR RegulationsEquality &amp; Diversity, Human RightsInfection ControlFood SafetyInformation Governance, GDPRRecords ManagementFraud &amp; Bribery PreventionConflict ResolutionLone Worker SafetyPractical Moving &amp; Handling (Level 2)Fire SafetyFreedom of InformationSafeguarding Adult &amp; Children (Level 3)Radicalisation AwarenessSlips, Trips &amp; Falls PreventionHealthcare Career InsightsPerson-Centered CareDuty of CareConsent ProtocolsEffective CommunicationPrivacy &amp; DignityComplaints HandlingPractical BLS &ndash; CPR &amp; Choking (Adults and Children)Mental Capacity Act &amp; DoLSMental Health Act AwarenessPractical (CPR Adults and Children, Moving &amp; Handling):Gain hands-on experience in vital life-saving skills with BLS - CPR &amp; Choking for Adults and Children. Also, master practical Moving &amp; Handling techniques (Level 2) for efficient patient care.CertificateReceive a certificate of proficiency upon successful completion of the course. Our course aligned with Skills for Health and the UK Resuscitation Council, offering professional growth and development opportunities.&nbsp;Our Course is also CPD Accredited and we have been awarded the Training Centre of Excellence.<img src="https://images.cademy.co.uk/ef-training-consultancy/71bc3b24-828c-4f0d-b310-3b8aca984ceb/original.png" style="width: 62px; display: inline-block; vertical-align: bottom; margin-right: 5px; margin-left: 5px; text-align: center; cursor: auto; max-width: calc(100% - 10px); padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 62px; display: inline-block; vertical-align: bottom; margin-right: 5px; margin-left: 5px; text-align: center; cursor: auto; max-width: calc(100% - 10px);" fr-original-class="fr-draggable"> Enrol now to elevate your skills and confidence in your role as agency nurses and HCAs.

Course Description:
Join us, agency nurses and HCAs, in our annual update course designed to ensure you remain current and competent. We offer a welcoming and comfortable learning environment to empower you with essential knowledge. 
Overview:
Stay up-to-date as agency nurses and HCAs. Our course provides a friendly and comfortable space for learning and growth, ensuring you're well-prepared for your role.
Key Learning Objectives:
Explore vital topics including:
Health & Safety, PPE
Covid Management
COSHH & RIDDOR Regulations
Equality & Diversity, Human Rights
Infection Control
Food Safety
Information Governance, GDPR
Records Management
Fraud & Bribery Prevention
Conflict Resolution
Lone Worker Safety
Practical Moving & Handling (Level 2)
Fire Safety
Freedom of Information
Safeguarding Adult & Children (Level 3)
Radicalisation Awareness
Slips, Trips & Falls Prevention
Healthcare Career Insights
Person-Centered Care
Duty of Care
Consent Protocols
Effective Communication
Privacy & Dignity
Complaints Handling
Practical BLS – CPR & Choking (Adults and Children)
Mental Capacity Act & DoLS
Mental Health Act Awareness
Practical (CPR Adults and Children, Moving & Handling):
Gain hands-on experience in vital life-saving skills with BLS - CPR & Choking for Adults and Children. Also, master practical Moving & Handling techniques (Level 2) for efficient patient care.
Certificate
Receive a certificate of proficiency upon successful completion of the course. Our course aligned with Skills for Health and the UK Resuscitation Council, offering professional growth and development opportunities. 
Our Course is also CPD Accredited and we have been awarded the Training Centre of Excellence.

Enrol now to elevate your skills and confidence in your role as agency nurses and HCAs.

EF Training & Consultancy Ltd

General Nursing

Adult Nurse

Food Safety

Child Safeguarding

Safeguarding

Nursing & Midwifery

GDPR

COSHH (Control of Substances Hazardous to Health)

Infection Control

Health & Safety, PPE
Covid         
COSHH & RIDDOR
Equality & Diversity, Human Rights
Infection Control
Food Safety
Information Governance
Data Protection (GDPR)
Records Management
Fraud & Bribery
Conflict Resolution
Lone Worker
Moving & Handling level 2(practical covered)
Fire Safety
Freedom of Information
Safeguarding Adult &                                Children level 3
Radicalisation
Slips Trips & Falls
Your Healthcare Career
Person Centred Care
Duty of Care
Consent
Communication
Privacy & Dignity
Complaints Handling
BLS –CPR & Choking for Adults and Children (practical covered)
Mental Capacity Act—DoLS
Mental Health Act 

Mandatory Refresher Training

Who should attend? Headteachers, DSLs, DDSLs, SENDCo, Family Support Workers, Pastoral Leads &amp; School Medical Staff. 

Overview 

This masterclass will help develop your confidence and knowledge in identifying and managing complex safeguarding issues.&nbsp;

It will help you to recognise Fabricated Induced Illness and to understand how to respond effectively when dealing with both parents and children. Additionally, we will cover other complex, challenging safeguarding issues such as addressing disguised compliance, dealing with cases of suspected child-parent abuse, and supporting children where parental mental health concerns are a complicating factor.

The masterclass will give you strategies in maintaining excellent records and chronologies of concerns as well as information on when and how to engage other professionals and agencies.

 Learning Objectives 

This Masterclass will enable you to:

<ul fr-original-style="" style="box-sizing: border-box;">
<li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Recognise and respond effectively to the signs and symptoms of FII, disguised compliance, child-parent abuse and parental mental health issues.</li>
<li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the short and long term impact on a child and their development.</li>
<li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How to compile detailed records and chronologies to evidence ongoing concerns.</li>
<li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Work collaboratively with multiple agencies and professionals, in line with the latest statutory guidance and legislation, to ensure a swift and effective response.</li></ul><a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;">View all testimonials </a>

Who should attend?
Headteachers, DSLs, DDSLs, SENDCo, Family Support Workers, Pastoral Leads & School Medical Staff.

Overview

This masterclass will help develop your confidence and knowledge in identifying and managing complex safeguarding issues. 
It will help you to recognise Fabricated Induced Illness and to understand how to respond effectively when dealing with both parents and children. Additionally, we will cover other complex, challenging safeguarding issues such as addressing disguised compliance, dealing with cases of suspected child-parent abuse, and supporting children where parental mental health concerns are a complicating factor.
The masterclass will give you strategies in maintaining excellent records and chronologies of concerns as well as information on when and how to engage other professionals and agencies.

Learning Objectives

This Masterclass will enable you to:
Recognise and respond effectively to the signs and symptoms of FII, disguised compliance, child-parent abuse and parental mental health issues.
Understand the short and long term impact on a child and their development.
How to compile detailed records and chronologies to evidence ongoing concerns.
Work collaboratively with multiple agencies and professionals, in line with the latest statutory guidance and legislation, to ensure a swift and effective response.
View all testimonials

Brightcore Consultancy

This masterclass will help develop your confidence and knowledge in identifying and managing complex safeguarding issues. 

Managing Complex Safeguarding Issues, including Fabricated Induced Illness, Disguised Compliance, Child Parent Abuse & Parental Mental Health Concerns

<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;">LOOKING FOR: ADULT FICTION, NON-FICTIONDiana 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. Diana was 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;Her list includes a wide range of bestselling and prize-winning authors in the UK and internationally.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. She has a thing for spy novels and would love to find a great vampire story.&nbsp;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.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;<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;">(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 I Am In Print).&nbsp;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.<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;">The submission deadline is: Wednesday 4 September 2024

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 20th May 2025 at 12 noon UK BST

I Am In Print

Fiction Writing

BOOKINGS CLOSED! 3 June Marilia Savvides #Agent121. Looking for: ADULT FICTION

Testimonials

"An inspiring and engaging course."
"Refreshing to hear the family's perspective."
"Your enthusiasm for the topic along with the knowledge and awareness you have given me has given me my mojo back! "

Summary 
This extensive, 2-3 day, CPD certified, blended course comprises of an interactive learning platform which includes:
Pre-recorded training videos (6-8.5hrs depending on modules accessed)
Downloadable independent learning workbook
Interactive on-line question forum through Padlet
Optional live practical problem solving events
Bonus videos focused on using night time positioning equipment
Final live review event with trainers Rachel Wright and Sarah Clayton (via Zoom)
On completion, delegates get access to materials designed for practitioners to deliver 24-hour postural care training to unpaid individuals and families who use their service

Please note that the course will take a minimum of 14 hours of independent learning with the option of completing further hours by covering more than one age bracket - the live sessions will be in addition to these 14 hours. Please ensure you allocate enough learning time to complete this course. It is expected that all independent learning is finished before the review events to enable you to fully participate in the discussions.
 	Date	Time (BST)
Introductory event & access to course content	23 Apr 2025	1300-1400 
Practical application session 1	 7 May 2025	 1300-1400
Practical application session 2	21 May 2025	 1100-1200
Final live review events	4 Jun 2025	 1030-1600
Course content access expires	18 Jun 2025	 
Details 
Using pre-recorded training, interactive on-line content (through Padlet), self-directed learning and live events, this substantial and comprehensive blended training course keeps delegates interested, engaged and learning new ways to bring excellence to their 24-hour postural care provision and focuses on the often neglected lying position and how unsupported lying drives changes to a person's body shape which impacts sitting, standing and functional movement. 

You will have access to the online learning from 23rd April 2025 and be provided with all the information you will need to complete the course. At 1pm (BST) on 23rd April you will then join the trainers for an introductory event via Zoom to provide an outline of the training and to answer any questions you may have. Over the next few weeks you can access the pre-recorded training videos and interactive online content to enable you to complete the workbook. On 4th June 2025 there will be a series of live discussion events for the specific ages the course covers to assess your learning (you must attend at least one of these events - please see below for further information). 

Why? 
People with complex needs, deserve a thorough, co-ordinated 24-hour postural care service. We only get one body and yet people with complex disabilities don't always get the 'annual service' afforded the equipment they use.
Posture Positive report (2020) found training is a key aspect to developing resilient and robust 24-hour postural care for people with complex needs. Every person with complex needs or limited movement requires a comprehensive 24-hour postural care service delivered in a personalised way. 

Who? 
The course is suitable for specialist physiotherapists, specialist occupational therapists and other highly trained healthcare professionals working in health, SEN and social care. 
The course breaks down the life span of a person as follows:
0-3 years
Children and young people in education
Adults
Older people and palliative care

Each delegate selects the aspects of the course relevant to their particular area of practice whilst having access to all the course resources.
What? 

On completion of the course, it is hoped delegates will be equipped with the knowledge needed to deliver an outstanding, person-centred, 24-hour postural care service. 

This course covers: 
Why is postural care such a big deal?
What is 24-hour postural care?
Identification of need
Predictable changes to body shape
Preventing, protecting and reversing body shape distortion
Postural care in the real world with real people
Special considerations for all stages of life
Monitoring and evaluating outcomes
Co-production in developing personalised postural care

You can focus on one specific age group or take a general approach allowing you to adapt the course to meet your own learning objectives. 

On 4th June the final live review events with the trainers via Zoom are available for the specific ages that the course covers. You must attend at least one of these live discussion (the one most relevant to your practice) but you are welcome to join all four. 
Please note the timings are BST.

10.30am - 11.30am 0-3 years
11.45am – 12.45pm Children in education
1.45pm - 2.45pm Adults
3.00pm - 4.00pm Older people and palliative care

Training for individuals and family carers
On successful completion of the course, all delegates will gain access to bespoke training materials designed by parents for parents of people with complex needs. This includes ongoing trainer support for local therapists hosting the workshops, pre-recorded training videos, workbook and designated webpage.
Group discounts
Contact us to book this training for your team, department or organisation with group discounts and bespoke training opportunities or if you would prefer to be invoiced directly for this training email admin@bornattherighttime.com 

Trainers 
Rachel Wright (BSc) Founder of Born at the Right Time Rachel is author of The Skies I'm Under, finalist 2020 RCN Nursing Awards, trainer, qualified nurse and unqualified mum of three sons; one of whom has severe disabilities and life-limiting epilepsy. Occasionally she ties on her trainers and runs in a vague attempt to counteract her love for Salt ‘n Vinegar crisps, hummus and all things carbohydrate. 

Sarah Clayton (BSc, PGCE) CEO Simple Stuff Works Sarah is passionate about all things postural care. Sounds dull but it turns out that her passion translates into highly contagious enthusiasm. She has developed a range of accredited training courses accessible to health, social care and education practitioners. Sarah has four children, works full-time and can regularly be found wearing her jumper inside out. 

Born at the Right Time

Physiotherapy

Occupational Therapy

Allied Health

Allied Health Professions (AHP)

Occupational Therapy Assistant

Palliative Care

Hospice & Palliative Medicine

Occupational Therapist

Health & Social Care

Physiotherapy Support Worker

End Of Life Care

Physiotherapist

CPD certified, digital study session, 24-hour postural care training, learning new ways to bring excellence to 24-postural care, focussing on supported lying. 

24-hour Postural Care from Cradle to Grave (Apr - Jun 25)

In an era where online presence is a necessity, understanding the fundamentals of search engine optimisation (SEO) is crucial for individuals and businesses alike. Navigating this dynamic landscape, can appear overwhelming and complicated for small business owners, but Let&rsquo;s Do Marketing are here to help. This 2-hour webinar breaks down the basics of SEO, providing you with the understanding of the core principles and highlights the tools available to help search engines to give you the attention you deserve! 📅 Date: Tuesday 19th November&nbsp;🕒&nbsp;Time: 10am - 12pm📌 Location: Online Webinar <span style='background: url("https://cdnjs.cloudflare.com/ajax/libs/emojione/2.0.1/assets/svg/1f4b7.svg"); display: inline-block; font-family: "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-weight: 400; line-height: 1; box-sizing: border-box; font-size: inherit; height: 1em; margin: -0.1em 0.1em 0.1em; min-height: 20px; min-width: 20px; vertical-align: middle; width: 1em;' fr-original-style="background: url(https://cdnjs.cloudflare.com/ajax/libs/emojione/2.0.1/assets/svg/1f4b7.svg);" fr-original-class="fr-emoticon fr-deletable fr-emoticon-img">&nbsp; Cost: &pound;25PP&nbsp; What You&#39;ll Learn:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understanding Search Engines: Gain insights into how search engines work and how they determine the ranking of web pages.</li><li fr-original-style="" style="box-sizing: border-box;">Keyword Research and Optimization: Learn how to strategically incorporate keywords into your content to increase visibility and attract the right audience.</li><li fr-original-style="" style="box-sizing: border-box;">On-Page SEO Techniques: Explore the critical on-page elements that contribute to a website&#39;s SEO success.</li><li fr-original-style="" style="box-sizing: border-box;">Off-Page SEO Strategies: Delve into off-page SEO factors, including backlink building and social signals. Understand how to cultivate a strong online presence beyond the confines of your website.</li><li fr-original-style="" style="box-sizing: border-box;">Technical SEO Essentials: Uncover the technical aspects of SEO, such as site speed, mobile optimization, and crawlability.</li><li fr-original-style="" style="box-sizing: border-box;">Measuring and Analysing SEO Performance: Explore key metrics and tools to measure the effectiveness of your SEO efforts.</li></ul>&nbsp;Who Should Attend: Small Business Owners Content Creators Entrepreneurs Anyone Seeking to Enhance Digital Presence Let&rsquo;s demystify SEO and empower you to navigate the digital landscape with confidence.&nbsp;About the Host:&nbsp;Stacey Pretty &ndash; Marketing Director, Let&rsquo;s Do Marketing<img src="https://images.cademy.co.uk/bdc6fb76-f48f-4ee1-adb0-87a4b88fa0c4/786e17a8-3713-45f9-999e-c12da4ced6dd/original.jpeg" style="width: 174px; display: inline-block; vertical-align: bottom; margin: 5px 15px 5px 0px; text-align: left; cursor: auto; max-width: calc(100% - 5px); float: left; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 174px; display: inline-block; vertical-align: bottom; margin: 5px 15px 5px 0px; text-align: left; cursor: auto; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable">Stacey is the Marketing Director of Let&rsquo;s Do Marketing, a marketing consultancy and services agency which is tailored to specifically support new and small businesses with organising and fulfilling their marketing ideas. With over 17 years of marketing experience, working in both B2B and B2C environments, Stacey has extensive experience in managing, creating, and promoting a variety of products and services using both online and offline marketing tools. Understanding the challenges faced by new and small businesses, Stacey seeks to simplify the complexities of marketing, with an approach focused on effectiveness and consistency, ensuring that every marketing effort translates into tangible results. For Stacey, marketing isn&#39;t just about campaigns; it&#39;s about building relationships and fostering an excellent customer experience.

In an era where online presence is a necessity, understanding the fundamentals of search engine optimisation (SEO) is crucial for individuals and businesses alike. Navigating this dynamic landscape, can appear overwhelming and complicated for small business owners, but Let’s Do Marketing are here to help.

This 2-hour webinar breaks down the basics of SEO, providing you with the understanding of the core principles and highlights the tools available to help search engines to give you the attention you deserve!

Event details:
Time: 10am - 12pm
Location: Online (ZOOM)
Cost: £30pp

What You'll Learn:
Understanding Search Engines: Gain insights into how search engines work and how they determine the ranking of web pages.
Keyword Research and Optimization: Learn how to strategically incorporate keywords into your content to increase visibility and attract the right audience.
On-Page SEO Techniques: Explore the critical on-page elements that contribute to a website's SEO success.
Off-Page SEO Strategies: Delve into off-page SEO factors, including backlink building and social signals. Understand how to cultivate a strong online presence beyond the confines of your website.
Technical SEO Essentials: Uncover the technical aspects of SEO, such as site speed, mobile optimization, and crawlability.
Measuring and Analysing SEO Performance: Explore key metrics and tools to measure the effectiveness of your SEO efforts.

Who Should Attend:
· Small Business Owners
Small Business Owners
Content Creators
Entrepreneurs
Anyone Seeking to Enhance Digital Presence

Let’s demystify SEO and empower you to navigate the digital landscape with confidence.




Meet the Host: 
Stacey Pretty | Marketing Director, Let’s Do Marketing

Stacey is the Marketing Director of Let’s Do Marketing, a marketing consultancy and services agency which is tailored to specifically support new and small businesses with organising and fulfilling their marketing ideas. With over 17 years of marketing experience, working in both B2B and B2C environments, Stacey has extensive experience in managing, creating, and promoting a variety of products and services using both online and offline marketing tools. Understanding the challenges faced by new and small businesses, Stacey seeks to simplify the complexities of marketing, with an approach focused on effectiveness and consistency, ensuring that every marketing effort translates into tangible results. For Stacey, marketing isn't just about campaigns; it's about building relationships and fostering an excellent customer experience.





Privacy Notice
By registering for this event, you agree to Let’s Do Business Group processing and managing your personal data in accordance with our Privacy Policy. Your data will only be used for the purposes of managing your event registration and any relevant communications.

Let’s Do Business Group

Local SEO

Seo Copywriting

Digital Marketing

Website Design

Google Seo

In an era where online presence is a necessity, understanding the fundamentals of search engine optimisation (SEO) is crucial for individuals and businesses alike.

SE..whO Breaking down the basics of SEO

Real Estate AnalystThe 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&hellip;<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> Who will benefit from this course?<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> Day OneKnow how to build a property asset cash flow, analyse geared, and un-geared IRRs.<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> Day TwoKnow how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.<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> Included in the Course<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> 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.comT - 01223 517851W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a>



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

Property & Real Estate Photography

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

<div id="course-pills-1">Duration1 Days6 CPD hoursThis course is intended forTo ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.OverviewUpon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.</div><div id="course-pills-2"><h4>Getting Started with Excel</h4><ul><li>Navigate the Excel User Interface</li><li>Use Excel Commands</li><li>Create and Save a Basic Workbook</li><li>Enter and Edit Cell Data</li><li>Fill Cells with Series of Data (AutoFill and Flash Fill)</li><li>Use Excel Help</li></ul><h4>Performing Calculations</h4><ul><li>Create Worksheet Formulas</li><li>Insert Functions and use Autocomplete</li><li>Reuse Formulas and Functions</li><li>Create an Absolute Reference</li></ul><h4>Modifying a Worksheet</h4><ul><li>Insert, Delete, and Adjust Cells, Columns, and Rows</li><li>Move and Copy Data between Cells</li><li>Search for and Replace Data</li><li>Use Spellcheck and Proofing</li></ul><h4>Formatting a Worksheet</h4><ul><li>Apply Text Formats</li><li>Apply Number Formats</li><li>Align Cell Contents</li><li>Apply and Copy Cell Styles</li><li>Apply Basic Conditional Formatting</li></ul><h4>Printing Workbooks</h4><ul><li>Preview and Print a Workbook</li><li>Controlling Page Layout</li><li>Adding Headers and Footers</li><li>Set Print Titles and Print Ranges</li></ul><h4>Managing Workbooks</h4><ul><li>Manage Worksheets</li><li>Insert and Delete Worksheets</li><li>Manage Workbook and Worksheet Views</li><li>Manage Workbook Properties</li></ul></div>

Duration
1 Days
6 CPD hours
This course is intended for
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.
Overview
Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.
This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.
Getting Started with Excel
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter and Edit Cell Data
Fill Cells with Series of Data (AutoFill and Flash Fill)
Use Excel Help
Performing Calculations
Create Worksheet Formulas
Insert Functions and use Autocomplete
Reuse Formulas and Functions
Create an Absolute Reference
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
Move and Copy Data between Cells
Search for and Replace Data
Use Spellcheck and Proofing
Formatting a Worksheet
Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply and Copy Cell Styles
Apply Basic Conditional Formatting
Printing Workbooks
Preview and Print a Workbook
Controlling Page Layout
Adding Headers and Footers
Set Print Titles and Print Ranges
Managing Workbooks
Manage Worksheets
Insert and Delete Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties

Nexus Human

Microsoft Office

Excel - Excel Essentials and Formulas

MOS Core Excel - 77-727 : Complete Techniques for Exam Success
Microsoft Certification (MOS) - Use your knowledge to become a Microsoft Office Specialist in Core Excel. This course will prepare you for the Microsoft Office Specialist Exam 77-727. The course provides an overview of the exam, the objective requirements set by Microsoft, tips on how to prepare and what to expect on the day of the test. It includes a comprehensive bank of test exercises which reflect the style of questions asked in the 77-727 Microsoft Core Excel exam. A comprehensive series of lectures are provided which cover every step needed to succeed. Become a Microsoft Office Specialist and Enhance Your Career
Use your knowledge to obtain certified status
Understand the 77-727 Exam
Learn how to correctly prepare for the test
Get advice from a seasoned professional who knows how to pass the exam
Core Excel with the MOS 77-727 Exam
This course is suitable for people at all levels of proficiency in Microsoft Excel. If you are new to the subject, then the course will lead you step by step through every single technique which is tested in the 77-727 exam. If you are already proficient in the use of Excel to some extent, then this course will help you to understand what is required in order to obtain a valuable certification in the subject. Every element of the objective domain for the 77-727 exam is comprehensively covered, together with exercises designed to ensure that you know the style and types of questions which you are required to answer in the exam. When you pass the 77-727 exam, Microsoft issue you with the MOS, or Microsoft Office Specialist certification status, in core Excel. Obtaining this certification provides tangible evidence that you are proficient in your use of Microsoft Excel and your LinkedIn profile will be automatically adjusted by Microsoft to reflect this achievement. If you follow and complete the course and exercises you will optimize your chances of gaining that qualification, you will enhance your status in your existing job and boost your job prospects in the marketplace. 
What You Will Learn
How to successfully pass the 77-727 Microsoft Certified Exam in Core Excel and become a Microsoft Office Specialist
Be confident and competent in your use of Microsoft Excel for everyday business use
Be ready to begin to study to become a certified Microsoft Office Specialist
Guarantee potential Employers of your competence in Microsoft Excel
Audience
This course is for students who are either total beginners with Microsoft Excel or who are intermediate users who want to obtain certification in Core Excel, existing users of Excel who want to learn how to pass the 77-727 exam and obtain official certification for their skills. 
Approach
The course explains how the exam is structured, the way that the questions should be approached and how to study successfully to pass. The course also includes invaluable advice on the best way to prepare and what to expect from the testing process. 
Key Features
Suitable for beginners or for anyone who has a reasonable knowledge of Microsoft Excel, this course is aimed at you obtaining certification status from Microsoft bypassing the 77-727 exam.
Github Repo
https://github.com/packtpublishing/77-727-microsoft-excel-certification---mos-excel-core-exam
About the Author
Dave Murphy
Dave Murphy - With over twenty years of experience as a systems analyst and project manager with significant experience in the design and implementation of major projects for some of the world's largest companies, Dave Murphy changed his career track in 2000 and has been a professional university educator for over 20 years. Dave is currently a lecturer in business information systems at the Technological University, Dublin. His main interests are in Microsoft certifications, project management, and business process analysis. Dave has a bachelor's in science (Hons) from Trinity College, Dublin, and a master's degree in computing. In addition to obtaining PRINCE2 Practitioner status, Dave is also a Microsoft Certified Professional in managing projects with Microsoft Project, is a MOS Master, and also a MOS examiner.
Course Outline
1. Introduction

1. What is the Microsoft Office Specialist (MOS) Certification?
Introduction: What is the Microsoft Office Specialist (MOS) Certification?
2. Understanding the Objective Domain
Introduction: Understanding the Objective Domain
3. How is the exam be conducted and what will it be like?
Introduction: How is the exam be conducted and what will it be like?
2. Introducing the Microsoft Excel User Interface

1. Introducing the Excel User Interface
Introducing the Microsoft Excel User Interface: Introducing the Excel User Interface
2. Essential Navigation Skills
Introducing the Microsoft Excel User Interface: Essential Navigation Skills
3. Entering Information
Introducing the Microsoft Excel User Interface: Entering Information
3. 1.1 Create Worksheets and Workbooks

1. 1.1.1 Create a Workbook
Create Worksheets and Workbooks: 1.1.1 Create a Workbook
2. 1.1.2 Importing Data from a Delimited Text File
Create Worksheets and Workbooks: 1.1.2 Importing Data from a Delimited Text File
3. 1.1.3 Add a Worksheet to an Existing Workbook
Create Worksheets and Workbooks: 1.1.3 Add a Worksheet to an Existing Workbook
4. 1.1.4 Copy and Move a Worksheet
Create Worksheets and Workbooks: 1.1.4 Copy and Move a Worksheet
5. Exercises Domain 1.1
Create Worksheets and Workbooks: Exercises Domain 1.1
4. 1.2 Navigate in Worksheets and Workbooks

1. 1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element
1.2 Navigate in Worksheets and Workbooks: 1. 2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element
2. 1.2.2 Named Ranges
1.2 Navigate in Worksheets and Workbooks: 1. 2.2 Named Ranges
3. 1.2.3 Insert and Remove hyperlinks
1.2 Navigate in Worksheets and Workbooks: 1. 2.3 Insert and Remove hyperlinks
4. Exercises Domain 1.2
Navigate in Worksheets and Workbooks: Exercises Domain 1.2
5. 1.3 Format Worksheets and Workbooks

1. 1.3.1 to 1.3.3 Changing Worksheet Characteristics
1.3 Format Worksheets and Workbooks: 1.3.1 to 1.3.3 Changing Worksheet Characteristics
2. 1.3.4 Modify Page Setup
1.3 Format Worksheets and Workbooks: 1.3.4 Modify Page Setup
3. 1.3.5 Insert and Delete Columns or Rows (and Cells)
1.3 Format Worksheets and Workbooks: 1.3.5 Insert and Delete Columns or Rows (and Cells)
4. 1.3.6 Change Workbook Themes
1.3 Format Worksheets and Workbooks: 1.3.6 Change Workbook Themes
5. 1.3.7 Adjust Row Height and Column Width
1.3 Format Worksheets and Workbooks: 1.3.7 Adjust Row Height and Column Width
6. 1.3.8 Insert Headers and Footers
1.3 Format Worksheets and Workbooks: 1.3.8 Insert Headers and Footers
7. Exercises Domain 1.3
Format Worksheets and Workbooks: Exercises Domain 1.3
6. 1.4 Customise Options and Views for Worksheets and Workbooks

1. 1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows
1.4 Customise Options and Views for Worksheets and Workbooks: 1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows
2. 1.4.4 Change Workbook Views
1.4 Customise Options and Views for Worksheets and Workbooks: 1.4.4 Change Workbook Views
3. 1.4.5 Change Window Views
1.4 Customise Options and Views for Worksheets and Workbooks: 1.4.5 Change Window Views
4. 1.4.6 Modify Document Properties
1.4 Customise Options and Views for Worksheets and Workbooks: 1.4.6 Modify Document Properties
5. 1.4.7 Change Magnification by using Zoom Tools
1.4 Customise Options and Views for Worksheets and Workbooks: 1.4.7 Change Magnification by using Zoom Tools
6. 1.4.8 Display Formulas
1.4 Customise Options and Views for Worksheets and Workbooks: 1.4.8 Display Formulas
7. Exercises Domain 1.4
Customise Options and Views for Worksheets and Workbooks: Exercises Domain 1.4
7. 1.5 Configure Worksheets and Workbooks for Distribution

1. 1.5.1. Set a Print Area
Configure Worksheets and Workbooks for Distribution: 1.5.1. Set a Print Area
2. 1.5.2 save Workbooks in Alternative File Formats
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.2 save Workbooks in Alternative File Formats
3. 1.5.3 Print All of Part of a Workbook
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.3 Print All of Part of a Workbook
4. 1.5.4 Set Print Scaling
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.4 Set Print Scaling
5. 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets
6. 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information
7. 1.5.7 Inspect a Workbook for Accessibility Issues
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.7 Inspect a Workbook for Accessibility Issues
8. 1.5.8 Inspect a Workbook for Compatibility Issues
1.5 Configure Worksheets and Workbooks for Distribution: 1.5.8 Inspect a Workbook for Compatibility Issues
9. Exercises 1.5
Configure Worksheets and Workbooks for Distribution: Exercises 1.5
8. 2.1 Insert Data in Cells and Ranges

1. 2.1.1 Replace Data
Insert Data in Cells and Ranges: 2.1.1 Replace Data
2. 2.1.2 Cut, Copy or Paste Data
Insert Data in Cells and Ranges: 2.1.2 Cut, Copy or Paste Data
3. 2.1.3 Paste Data by using Special Paste Options
Insert Data in Cells and Ranges: 2.1.3 Paste Data by using Special Paste Options
4. 2.1.4 Fill Cells by using Auto Fill
Insert Data in Cells and Ranges: 2.1.4 Fill Cells by using Auto Fill
5. 2.1.5 Insert and Delete Cells
Insert Data in Cells and Ranges: 2.1.5 Insert and Delete Cells
6. Exercises Domain 2.1
Insert Data in Cells and Ranges: Exercises Domain 2.1
9. 2.2. Format Cells and Ranges

1. 2.2.1 Merge Cells
Format Cells and Ranges: 2.2.1 Merge Cells
2. 2.2.2 Modify Cell Alignment and Indentation
Format Cells and Ranges: 2.2.2 Modify Cell Alignment and Indentation
3. 2.2.3 Format Cells by using Format Painter
Format Cells and Ranges: 2.2.3 Format Cells by using Format Painter
4. 2.2.4 Wrap Text within Cells
Format Cells and Ranges: 2.2.4 Wrap Text within Cells
5. 2.2.5 Apply Number Formats
Format Cells and Ranges: 2.2.5 Apply Number Formats
6. 2.2.6 Apply Cell Formats
Format Cells and Ranges: 2.2.6 Apply Cell Formats
7. 2.2.7 Apply Cell Styles
Format Cells and Ranges: 2.2.7 Apply Cell Styles
8. Exercises Domain 2.2
Format Cells and Ranges: Exercises Domain 2.2
10. 2.3 Summarise and Organise Data

1. 2.3.4 Apply Conditional Formatting
2.3 Summarise and Organise Data: 2.3.4 Apply Conditional Formatting
2. Exercises Domain 2.3
Summarise and Organise Data: Exercises Domain 2.3
11. 3.1 And 3.2 Create and Manage Tables

1. 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse
And 3.2 Create and Manage Tables: 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse
2. 3.1.3 Add or Remove Table rows and Columns
And 3.2 Create and Manage Tables: 3.1.3 Add or Remove Table rows and Columns
3. 3.2.1 to 3.2.3 Table Styles
And 3.2 Create and Manage Tables: 3.2.1 to 3.2.3 Table Styles
4. Exercises Domain 3.1 and 3.2
And 3.2 Create and Manage Tables: Exercises Domain 3.1 and 3.2
12. 3.3 Filter and Sort a Table

1. 3.3.1 Filter Records
3.3 Filter and Sort a Table: 3. 3.1 Filter Records
2. 3.3.2 and 3.3.3 Sort Data
3.3 Filter and Sort a Table: 3. 3.2 and 3.3.3 Sort Data
3. 3.3.4 Remove Duplicate Records
Filter and Sort a Table: 3.3.4 Remove Duplicate Records
4. Exercises Domain 3.3
Filter and Sort a Table: Exercises Domain 3.3
13. 4.1 Summarise Data by Using Functions

1. 4.1.1 (Part I) Insert References
Summarise Data by Using Functions: 4.1.1 (Part I) Insert References
2. 4.1.1 (Part II) Absolute References
Summarise Data by Using Functions: 4.1.1 (Part II) Absolute References
3. 4.1.2 Perform Calculations by using the SUM Function
Summarise Data by Using Functions: 4.1.2 Perform Calculations by using the SUM Function
4. 4.1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions
Summarise Data by Using Functions: .1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions
5. 2.3.2 Outline Data
Summarise Data by Using Functions: 2.3.2 Outline Data
6. 2.3.3 Insert Subtotals
Summarise Data by Using Functions: 2.3.3 Insert Subtotals
7. Exercises Domain 4.1
Summarise Data by Using Functions: Exercises Domain 4.1
14. 4.2 Perform Conditional Operations by Using Functions

1. 4.2.1 Perform Logical Operations by using the IF Function
Perform Conditional Operations by Using Functions: 4.2.1 Perform Logical Operations by using the IF Function
2. 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions
Perform Conditional Operations by Using Functions: 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions
3. Exercises Domain 4.2
Perform Conditional Operations by Using Functions: Exercises Domain 4.2
15. 4.3 Format and Modify Text by Using Functions

1. 4.3.1 Format Text by using RIGHT, LEFT and MID Functions
Format and Modify Text by Using Functions: 4.3.1 Format Text by using RIGHT, LEFT and MID Functions
2. Exercises Domain 4.3
Format and Modify Text by Using Functions: Exercises Domain 4.3
16. 5.1 Create Charts

1. 5.1.1 Create a New Chart
Create Charts: 5.1.1 Create a New Chart
2. 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns
Create Charts: 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns
3. 5.1.4 Analyse Data by using Quick Analysis
Create Charts: 5.1.4 Analyse Data by using Quick Analysis
4. 2.3.1 Insert Sparklines
Create Charts: 2.3.1 Insert Sparklines
5. Exercises Domain 5.1
Create Charts: Exercises Domain 5.1
17. 5.2 Format Charts

1. 5.2.1 Resize Charts
Format Charts: 5.2.1 Resize Charts
2. 5.2.2 Add and Modify Chart Elements
Format Charts: 5.2.2 Add and Modify Chart Elements
3. 5.2.3 and 5.2.4 Apply Chart Layouts and Styles and Move Charts
Format Charts: 5.2.3 and 5.2.4 Apply Chart Layouts and Styles and Move Charts
4. Exercises Domain 5.2
Format Charts: Exercises Domain 5.2
18. 5.3 Insert and Format Objects

1. 5.3.1 Insert Text Boxes and Shapes
Insert and Format Objects: 5.3.1 Insert Text Boxes and Shapes
2. 5.3.2 Insert Images
Insert and Format Objects: 5.3.2 Insert Images
3. 5.3.3 Modify Object Properties
Insert and Format Objects: 5.3.3 Modify Object Properties
4. 5.3.4 Add Alternative Text to Objects for Accessibility
Insert and Format Objects: 5.3.4 Add Alternative Text to Objects for Accessibility
5. Exercises Domain 5.3
Insert and Format Objects: Exercises Domain 5.3

Packt

MOS Core Excel - 77-727 : Complete Techniques for Exam Success

13660 Courses

Construction Project Manager 2 Days Training in Maidstone

By Mangates

Construction Project Manager 2 Days Training in York

By Mangates

Construction Project Manager 2 Days Training in Leeds

By Mangates

Construction Project Manager 2 Days Training in Plymouth

By Mangates

An Introduction to Real Estate in Excel (Financial Modelling)

By Bayfield Training

Real Estate Developer (Development Cash Flow Modelling in Excel)

By Bayfield Training

Microsoft Excel Training

By FourSquare Innovations Ltd

Power Excel 1 (the essentials)

By dbrownconsulting

Mastering Excel

By Sterling Training

Mandatory Refresher Training

By EF Training & Consultancy Ltd

Search By Location