Name: Sales Management 2 Days Training in Darlington
Price: 1195 GBP
Availability: InStock

<div>
									<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h2>Overview</h2>		</div>
				</div>
				<div>
				<div>
							Microsoft Excel Course for Everyone - Complete Excel Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Excel Course for Everyone - Complete Excel Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills.Consisting of several modules, the course teaches you everything you need to succeed in this profession.The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website.						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h3>Why Choose Teachers Training</h3>		</div>
				</div>
				<div>
				<div>
			Some of our website features are:		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											
													
										This is a dedicated website for teaching
									</li>
								<li>
											
													
										24/7 tutor support
									</li>
								<li>
											
													
										Interactive Content
									</li>
								<li>
											
													
										Affordable price
									</li>
								<li>
											
													
										Courses accredited by the UK's top awarding bodies
									</li>
								<li>
											
													
										100% online 
									</li>
								<li>
											
													
										Flexible deadline
									</li>
						</ul>
				</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h3> Entry Requirements
</h3>		</div>
				</div>
				<div>
				<div>
			No formal entry requirements. You need to have:		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											
													
										Passion for learning
									</li>
								<li>
											
													
										A good understanding of the English language
									</li>
								<li>
											
													
										Be motivated and hard-working
									</li>
								<li>
											
													
										Over the age of 16.
									</li>
						</ul>
				</div>
				</div>
					</div>
		</div>
							</div>
		</section>
				<section>
						<div>
					<div>
			<div>
								<div>
				<div>
			<h3>Certification</h3>		</div>
				</div>
				<div>
				<div>
							CPD Certification from The Teachers TrainingSuccessfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.<ul><li>You can get your digital certificate (PDF) for £4.99 only</li><li>Hard copy certificates are also available, and you can get one for only £10.99</li><li>You can get both PDF and Hard copy certificates for just £12.99!</li></ul>The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.						</div>
				</div>
					</div>
		</div>
							</div>
		</section>
							</div><table width="100%">				<tbody><tr>
					<td colspan="4">Section 01: Getting Started</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Course Curriculum</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Getting started on Windows, macOS, Android, and IOS</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to ask great questions</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FAQ's</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Starting Excel</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 02: Excel Basics</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Worksheet basics</td>
					<td> </td>
					<td> 00:22:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Entering values and formulas</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data formats</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data handling basics - cut copy and paste</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Save and print in excel</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Excel Ranges</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 03: Excel essential functions</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Basic formula operations</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Mathematical functions level 1</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Mathematical functions level 2</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Text functions level 1</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Text functions level 2</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Logical functions</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Date time functions</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>V Lookup formula</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>HLookup formula</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>HLookup + Match formula</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Match + Index formula</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 04: XLookup only for Excel 2021 and Office 365</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>XLookup</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Handling #NA and Approximates match in XLookup</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Wildcard matching in XLookup</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 05: Get Data and tools</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Split text into columns</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Flash Fill</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Remove Duplicates</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Validation</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Get- import Data from Text</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Get - import Data from CSV</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 06: Formatting data and tables</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formatting Font</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formatting Alignment</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formatting Number</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formatting Date</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formatting tables</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 07: Pivot Tables</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Pivot Table</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Value field settings</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Number format</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Pivot Table Design</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Excel Exercise</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Solution for Excel Exercise</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 08: Excel Charts</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Excel Charts - Categories</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Elements of a chart</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Easy way to create charts</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Column or Bar charts</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Formatting charts</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Line charts</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Area charts</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Pie and Doughnut charts</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Format AreaPlot or XY chart</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Scatter or bubble charts</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 09: Advanced Excel charts</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Frequency Distribution and Histograms</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Waterfall charts</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Hierarchy charts: sunburst and tree map</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Combination charts</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sparklines</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 10: Pivot Charts</td>
				</tr>
								<tr>
					<td></td>
					<td>Pivot charts</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 11: Maps Chart above 2019</td>
				</tr>
								<tr>
					<td></td>
					<td>Maps chart</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>3D Maps chart</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 12: Business-Geo charts</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Stock charts</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Radar charts</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Surface charts</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Heat maps</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 13: Named Ranges</td>
				</tr>
								<tr>
					<td></td>
					<td>Named ranges</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Indirect Name range Function</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 14: Import Data into Excel</td>
				</tr>
								<tr>
					<td></td>
					<td>Import Data table from PDF file - Excel 2021</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Import Data from Website - Excel 2019 above</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 15: Advanced Excel</td>
				</tr>
								<tr>
					<td></td>
					<td>Project: Sales forecast tracker</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Product Sale Tax invoice: Tax Calculations</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
				</tbody></table>

Microsoft Excel Course for Everyone – Complete Excel Course is yet another “Teacher’s Choice” course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Microsoft Excel Course for Everyone – Complete Excel Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills.
Consisting of several modules, the course teaches you everything you need to succeed in this profession.
The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website.
Course Curriculum
Section 01: Getting Started
Section 02: Excel Basics
Section 03: Excel essential functions
Section 04: XLookup only for Excel 2021 and Office 365
Section 05: Get Data and tools
Section 06: Formatting data and tables
Section 07: Pivot Tables
Section 08: Excel Charts
Section 09: Advanced Excel charts
Section 10: Pivot Charts
Section 11: Maps Chart above 2019
Section 12: Business-Geo charts
Section 13: Named Ranges
Section 14: Import Data into Excel
Section 15: Advanced Excel
Why Choose Teachers Training
Some of our website features are:
This is a dedicated website for teaching
24/7 tutor support
Interactive Content
Affordable price
Courses accredited by the UK's top awarding bodies
100% online
Flexible deadline
Entry Requirements
No formal entry requirements. You need to have:
Passion for learning
A good understanding of the English language
Be motivated and hard-working
Over the age of 16.
Certification
CPD Certification from The Teachers Training
Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.
You can get your digital certificate (PDF) for £4.99 only
Hard copy certificates are also available, and you can get one for only £10.99
You can get both PDF and Hard copy certificates for just £12.99!
The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

The Teachers Training

Microsoft Certification

Microsoft Excel

Trainers Course

Unlock the full potential of Microsoft Excel with our course for everyone. Learn essential skills and advanced techniques to excel in any data-driven role.

Microsoft Excel Course for Everyone - Complete Excel Course

General Admission

Burton Upon Trent

<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 Overview:

A successful sales manager's job is to provide clear direction and support to his/her team  enabling them to excel and develop to reach their full potential.  Sales managers often rise to this position from a successful career in sales. But the skills required of a successful sales manager are quite different from the skills of a sales person which is one of the key points that this program will be focusing on. 

This two day program will enable delegates to have a clear understanding of the successful sales manager's responsibilities and how to become more effective in their roles in this challenging competitive business environment of today. Over the period of the course delegates will explore key leadership skills as well as the essential sales managerial skills needed for them to effectively forecast and implement effective sales plans, motivate, monitor and evaluate the performance of their people and provide the required direction and support ensuring measurable sales results from their sales teams.

This course also includes several bonus forms that were designed to help you prepare your sales forecast and complete sales plan. (Forecast data form, Sales plan support form)

Learning Objectives:

After completing this course, delegates will be able to: 

Understand the roles and responsibilities of a sales manager
Learn skills to achieve better results through their teams using sales plans and targeting techniques
Clearly understand how to prepare a sales forecast and a sales plan for their sales operation
Properly observe, evaluate and give feedback to team members and set performance development objectives using assessment tools supplied and provided within the training program
Explore ways to motivate their sales teams and create a more motivating environment.
Run more effective sales meetings and morning huddles to inspire and motivate and provide clear direction to their sales team members.

Agenda:

Introduction - A sales management primer

What is your job?
Sales Manager Versus Salesman.
The perfect salesperson- Activity

Module 1 : A Strategic look at sales management:
Sales management - is it strategic or tactical?
What are my CSF's? - Critical success factors.
SWOT and PESTLE analysis.

Module 2 : Sales Forecasting:
What is forecasting and how it can help sales performance?
Identify different forecasting methods.
Follow a simple 4 step process to create a sales forecast.
Avoid common forecasting pitfalls.

Module 3 : Sales Planning:
Setting up your sales strategy.
Put together the main components of your sales plan.
Specify sales tactics to achieve strategy.
Sales planning best practice examples.
Practical skill practice activity - Create a sales plan for your sales operation.

Module 4 : Sales performance management:
Setting sales objectives.
The 3 step sales performance control plan.
Guidelines for proper sales performance evaluation.
Handling the underperforming sales team member.

Module 5 : Motivating your sales team:
What motivates us?
Knowing your team inside out.
Creating a motivating environment for your team.
Understand the factors that combine and drive personal motivation.

Module 6 : Running effective sales meetings:
Effective versus badly run sales meetings
Planning your sales meeting sequence.
Successful sales meeting checklist.
Team huddle versus team meeting.

Certification:

Once after the training you receive course completion certificate from Mangates.

Target Audience:

Sales Managers

Mangates

Sales Management 2 Days Training in Burton Upon Trent

The sale ends 10 days before the event starts.

Early Bird Fee

The sale ends 5 days before the event starts.

Standard Fee

Bournemouth

Sales Management 2 Days Training in Bournemouth

Bracknell

Sales Management 2 Days Training in Bracknell

Bromley

Sales Management 2 Days Training in Bromley

Bolton

Sales Management 2 Days Training in Bolton

Dumfries

Sales Management 2 Days Training in Dumfries

Dundee

Sales Management 2 Days Training in Dundee

Dunfermline

Sales Management 2 Days Training in Dunfermline

Darlington

Sales Management 2 Days Training in Darlington

<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 FICTIONKate Barker has worked in publishing for over twenty years as an agent, commissioning editor and ghostwriter. Before setting up her own company, Kate Barker Literary Agency, she spent ten years at Penguin, where she was an Editorial Director for Viking, acquiring fiction and non-fiction. She has also worked for Orion, Curtis Brown and for digital publisher Bookouture.She is looking for commercial and reading group fiction for adults and would love to find an unputdownable thriller like Rosamund Lupton&#39;s Three Hours, a funny, heartbreaking contemporary novel like Queenie by Candice Carty-Williams or a romantic comedy with a unique premise like The Flatshare by Beth O&#39;Leary. She also loves historical fiction and series crime.Kate would like you to submit a covering letter, one page synopsis and the first three chapters (Max 5,000 words) of your completed manuscript in a single word document.<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, Kate is kindly offering one free session for low income/under-represented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the&nbsp;discretion of&nbsp;I Am In Print).&nbsp;By booking you understand you need to conduct an internet connection test with&nbsp;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: Monday 23 September 2024

LOOKING FOR: ADULT FICTION, SCIENCE FICTION / FANTASY

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

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

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

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

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

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

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

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

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

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

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

The submission deadline is: Tuesday 3rd June 2025

I Am In Print

SOLD OUT! 10th June Hannah Todd #Agent121. Looking for: ADULT FICTION

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

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

Sixty minute webinar on Rally Regularity Timing covering equipment required, how to keep to time, working out penalties and speed changes, this webinar focuses on styles of regularity that require the use of standard average speed tables. The competitive component of on the public highway historic road rallying, focusing on regularity using average speed tables. Ideal for competitors on events such as HRCR Clubmans Championship or Rally of the Tests

Mastering Regularity Rallying: A 60-Minute Webinar
Elevate your rallying skills with this focused, one-hour webinar designed to boost your confidence in regularity time keeping, essential for competitive historic road rallying on public highways. Dive into the essentials of average speed tables, timing strategies, and control procedures, and gain insider tips for recovering from common mistakes to stay on course. Perfect for competitors aiming to excel in top-tier events like the HERO Rally of the Tests or HRCR Championship rallies, this webinar offers practical insights to enhance your performance. Join us to refine your skills and gain a competitive edge!

Rally Navigation Training Services

Sports & Fitness

Historic Road Rallying training webinar on Regularity focusing on Average Speed Table style regularities.

Rally Navigation - Regularity for Improvers

London

<h2 style="color: rgb(1, 45, 113); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(1, 45, 113);">About this course</h2>Do you struggle to engage your lower attaining or EAL pupils in their history lessons? Are you finding it difficult to ensure and demonstrate progression in history with these pupils?According to Department for Education statistics, in 2020 there were 1.4 million pupils across the UK with identified special educational needs and this number is growing every year. Many of these pupils are in mainstream schools, where reporting shows pupils can have widely differing experiences and are more likely to have poorer outcomes relative to their peers. Ofsted has reported many strengths and weaknesses in SEND support. Among areas of weakness are a lack of curriculum well matched to pupil needs and effective collaboration between teachers, teaching assistants and parents.As evidence from the Education Endowment Fund supports, high quality teaching for pupils with SEND is often based upon strategies that most teachers will already have in their repertoires: scaffolding, explicit verbal interaction and instruction, cognition and metacognition, use of technology and collaboration.This full day session, aimed at history subject leaders in mainstream schools, will give you strategies and approaches to adapt, adopt and try in history. It will not provide all the answers, but you will leave the session with lots to think about and lots of practical ideas and advice to try in school and share with staff teaching history.The day will cover strategies for supporting both Key Stage 1 and 2 pupils.<h3 style="color: rgb(1, 45, 113); box-sizing: border-box;" fr-original-style=" color: rgb(1, 45, 113);">Objectives for the day</h3>To give you some space and time to think about and identify the needs of your lower attaining and EAL pupils and how you could adapt your teaching of history and your curriculum to suit their needs.To introduce, or revisit the implementation of a range of different strategies to support your lower attaining pupils, focused on general teaching, writing and the use of vocabulary in our history lessons.<h3 style="color: rgb(1, 45, 113); box-sizing: border-box;" fr-original-style=" color: rgb(1, 45, 113);">Outcomes</h3>You will have a clear understanding of a range of strategies you could use, you will leave feeling more confident about how you can adapt your history teaching to support the engagement and progress of your lower attaining pupils and you will have some identified actions to help you achieve this.<h3 style="color: rgb(1, 45, 113); box-sizing: border-box;" fr-original-style=" color: rgb(1, 45, 113);">Course leader</h3>Sue Temple was a Primary and Early Years teacher for 17 years, including 10 years as an SEN teacher, before moving into initial Teacher Education as a Senior Lecturer in Primary History where she has led the History specialism at the University of Cumbria since 2004. Sue has also been a Quality Mark assessor for the Historical Association since the Quality Mark began, which has given her the opportunity to observe some excellent practice and ideas to share with you.<p data-key="12" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyMGxlYWRlcnMlM0ElMjBDaHJpcyUyMFRyZXZvciUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTVEJTdEJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIyYmxvY2slMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYnVsbGV0ZWQtbGlzdCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJsaXN0LWl0ZW0lMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyMiUyME5vdmVtYmVyJTIwMjAyMyUyQyUyMDFwbSUyMC0lMjA0JTNBMzBwbSUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybWFyayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJib2xkJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiU3RCU3RCU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMmxpc3QtaXRlbSUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjIxJUVGJUJCJUJGNiUyME5vdmVtYmVyJTIwMjAyMyUyQyUyMDFwbSUyMC0lMjA0JTNBMzBwbSUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybWFyayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJib2xkJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiU3RCU3RCU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJKb2luJTIwdXMlMjBmb3IlMjB0aGlzJTIwdHdvLXBhcnQlMjBvbmxpbmUlMjBjb3Vyc2UlMjBpbiUyMHdoaWNoJTIwQ2hyaXMlMjBUcmV2b3IlMjB3aWxsJTIwdGFrZSUyMHlvdSUyMG9uJTIwYSUyMGpvdXJuZXklMjB0aHJvdWdoJTIwdGhlJTIwbW9zdCUyMGltcG9ydGFudCUyMGVsZW1lbnRzJTIwb2YlMjBwcmltYXJ5JTIwaGlzdG9yeSUyMHN1YmplY3QlMjBsZWFkZXJzaGlwLiUyMFlvdSUyMG1heSUyMGJlJTIwbmV3JTIwdG8lMjB0aGUlMjByb2xlJTIwb3IlMjBlc3RhYmxpc2hlZCUyMGJ1dCUyMHdvdWxkJTIwbGlrZSUyMHRvJTIwaGF2ZSUyMHNvbWUlMjBmb3JtYWwlMjB0cmFpbmluZyUyMHRvJTIwY2FycnklMjBvdXQlMjB0aGUlMjByb2xlJTIwbW9yZSUyMGVmZmVjdGl2ZWx5JTJDJTIwcGFydGljdWxhcmx5JTIwaW4lMjBsaWdodCUyMG9mJTIwdGhlJTIwbmV3JTIwT2ZzdGVkJTIwZWR1Y2F0aW9uJTIwaW5zcGVjdGlvbiUyMGZyYW1ld29yay4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"> <h2 data-key="15" fr-original-style="" style="box-sizing: border-box;"> </h2>

About this course

This practical course will help primary teachers to understand the purpose of assessment in history and consider current best practice. We will explore ways of continuing to improve the quality of teaching and learning in history through effective assessment strategies. We will go through practical ideas and resources to enliven teaching and learning in history and provide opportunities for assessment. This course will provide guidance and support to help develop the accuracy of teacher judgements. During the course, we will look at examples of writing and outcomes from different schools and consider how these outcomes demonstrate progress and attainment in history.

Outcomes
• understand the purpose of assessment in history
• consider current best practice
• explore ways of continuing to improve the quality of teaching and learning in history through effective assessment strategies
• explore practical ideas and resources to enliven teaching and learning in history and provide opportunities for assessment
• provide guidance and support to help develop the accuracy of teacher judgements
Course leader
The course is led by Steven Kenyon. Steven is a member of the Historical Association’s primary committee, having worked as a primary school teacher and then Deputy Head Teacher between 2004 and 2018. He joined Lancashire Professional Development Service in April 2018 as a Teaching and Learning Consultant for Primary History and English. He works closely with Lancashire Archives to promote and develop local history work in primary schools. This year he is a judge for the Historical Association's Young Quills Awards.






Historical Association

HA Course: Assessment and progression in primary history

Must have a full paid membership with the Historical Association

Historical Association member

Non member

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

Financial Risk Management

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

Real Estate Developer (Development Cash Flow Modelling in Excel)

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

<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

Office Skills & Productivity

Office Skills

Microsoft Office

Spreadsheet

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

77-727 Microsoft Excel Certification - MOS Excel Core Exam

Are you self-taught in Excel? Our "Fundamentals of Excel" course provides you with a good refresher of the tricks of the trade and some quick easy wins. Making time spent on spreadsheets efficient, effective and painless!<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;">11 June , 13 June, 18 June and 20 June</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>

Are you self-taught in Excel? Our "Fundamentals of Excel" course provides you with a good refresher of the tricks of the trade and some quick easy wins. Making time spent on spreadsheets efficient, effective and painless!
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)
11 June , 13 June, 18 June and 20 June
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

Learn Excel tricks of the trade and some quick easy wins, to make time spent on spreadsheets efficient, effective and painless!

13659 Courses

Microsoft Excel Course for Everyone - Complete Excel Course

By The Teachers Training

Sales Management 2 Days Training in Burton Upon Trent

By Mangates

Sales Management 2 Days Training in Bournemouth

By Mangates

Sales Management 2 Days Training in Bracknell

By Mangates

Sales Management 2 Days Training in Bromley

By Mangates

Sales Management 2 Days Training in Bolton

By Mangates

Sales Management 2 Days Training in Dumfries

By Mangates

Sales Management 2 Days Training in Dundee

By Mangates

Sales Management 2 Days Training in Dunfermline

By Mangates

Sales Management 2 Days Training in Darlington

By Mangates

Search By Location