Name: Microsoft Excel Advanced - In-company
Price: 650 GBP
Availability: InStock

Loughborough

<div>
		

		<div>
			
			<p>Build confidence &amp; capability and engage in meaningful dialogue about race.</p>
			<div><i></i> 3 x 180mins</div>
			<div><i></i>  £670.00 incl. VAT</div>
			
			
		</div>
	</div>

	

	<div id="filters">
		
		
	</div>

	

    <div>

		
		 
		

		<div></div>

		<div>
			<p>Want to run this event in-house?  Enquire about running this event in-house </p>
			
		</div>

		<div>
			<p>Interested in attending? Have a suggestion about running this event near you?<br />Register your interest now</p>
			
		</div>
	</div>
	<div></div>
	
		
        <div>
			
		</div>
				

	
		<h3>Description</h3>
		<p></p><p><span>Discussing EDI in the workplace can be a sensitive matter, through race talks you can ignite individuals and groups to co-create inclusive work environments where everyone can perform and do their best work effectively without bending themselves out of shape to fit in.</span></p>
<h2><span>What is race talks and how is it different?</span></h2>
<p>Race talks focuses us on what matters most, the impact of our collective efforts to accomplish your organisational EDI goals. Race Talks brings substantial and sustainable effectiveness to personal leadership and team development.</p>
<p><span>The Race Talks program</span> is a transparent way of seeing, being and working that helps individuals, teams and organizations go beyond themselves.</p>
<p>'Those that identify and address Mindset at the outset of the transformation process, have a +400% greater probability to succeed in change' Source: Mckinsey Quarterly</p>
<p>Race Talks focuses on what drives and informs our behaviours, our mindset. Many personal development solutions attempt to improve results by helping people to change behaviours. Focusing on behaviours alone is insufficient.</p>
<p><strong>Available as private Face to Face and virtual sessions (max 12 delegates) - £2,617.50  Plus VAT</strong></p>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><h3>Participant Outcomes:</h3>
<p>Experience how to create and leverage powerful, positive, and lasting impact, empowering your professional and personal relationships</p>
<p> </p>
<ul>
<li>Understand and experience the underlying unconscious mindset and the implications on your interactions, relationships and organizational health</li>
<li>Be the role model for an inclusive mindset &amp; behaviours</li>
<li>Learn to honestly assess, the extent to which you or others are working with a conscious (or unconscious) mindset</li>
<li>Positively influence yourself and your teams to be more engaged and productive</li>
<li>Learn to work or interact with ease and authenticity, in times of ambiguity and uncertainty, in a way that is more collaborative, inclusive, fulfilling and ultimately effective</li>
</ul>
<h3><span>Module 1 - Outline</span></h3>
<div>
<ul>
<li>Raise Awareness, creating from ourselves</li>
<li>Pre &amp; post assignment work</li>
<li>Evaluation</li>
</ul>
<h3><span>Module 2 - Outline</span></h3>
<div>
<ul>
<li>System awareness &amp; creating with others</li>
<li>Pre &amp; post assignment work</li>
<li>Evaluation</li>
</ul>
<h3><span>Module 3 - Outline</span></h3>
<div>
<ul>
<li>Inspire &amp; Engage in Accountable Action</li>
<li>Pre &amp; post assignment work</li>
<li>Evaluation</li>
</ul>
</div>
</div>
</div>
<p></p>

Mpi Learning - Professional Learning And Development Provider

Build confidence & capability and engage in meaningful dialogue about race.

Let's Talk About Race (EDI)

General Admission

<div>
		

		<div>
			
			<p>All organizations have policies and procedures that guide how decisions are made and how the work is done in that organization. Professionally written policies and procedures increase organizational accountability and transparency and are fundamental to quality/standards assurance and quality improvement. </p>
			<div><i></i> 3 x 4 Hour Sessions</div>
			<div><i></i>  £667.50 incl. VAT</div>
			
			
		</div>
	</div>

	

	<div id="filters">
		
		
	</div>

	

    <div>

		
		 
		

		<div></div>

		<div>
			<p>Want to run this event in-house?  Enquire about running this event in-house </p>
			
		</div>

		<div>
			<p>Interested in attending? Have a suggestion about running this event near you?<br />Register your interest now</p>
			
		</div>
	</div>
	<div></div>
	
		
        <div>
			
		</div>
				

	
		<h3>Description</h3>
		<p></p><h4><span>All organizations have policies and procedures that guide how decisions are made and how the work is done in that organization. Professionally written policies and procedures increase organizational accountability and transparency and are fundamental to quality/standards assurance and quality improvement. Policies and procedures help organizations to commit themselves explicitly to the development of a culture that recognises the importance of quality, and quality assurance, in their work. To achieve this, institutions should develop and implement a strategy for the continuous enhancement of quality. This program explains how.<br /></span></h4>
<p> </p>
<p><strong>Available as private Face to Face and virtual sessions (max 12 delegates) - £2,617.50 Plus VAT</strong></p>
<p> </p>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><h3><b>Phased Approach </b></h3>
<p>This virtual course consists of three sessions of 4 hours each. We recommend a phased approach with an interval of at least one week between sessions. These intervals are used to apply the ideas acquired during each session in each participant's normal work. This ensures that the progression from theory to practice is realized.</p>
<h3><b>Session Recording</b></h3>
<p>This courses uses (Zoom or WebEx) online technology. Full instructions will be given to facilitate easy access. Participants will receive PowerPoint slides, a guide to writing policies and procedures and, if requested, a recording of each session is available to download for one month after each session. Once downloaded, however, you can keep and review the content as often as required. Participants will be invited to join a secure LinkedIn Group where they will have access to course materials, share materials and have their questions answered.</p>
<h3><b>Course Objectives </b></h3>
<ul>
<li>Identify the necessity for having good organizational policies and procedures.</li>
<li>Understand the differences between 'policies' and 'procedures'.</li>
<li>Understand the link between an organization's values, and its policies and procedures.</li>
<li>Learn the process of writing clear policies and procedures.</li>
<li>Examine writing formats and writing styles.</li>
<li>Practice writing clear, effective, policies and procedures.</li>
<li>Understand the necessity of regularly updating, reviewing, and revising our organization's policies and procedures.</li>
</ul>
<h3><b>Course Content </b></h3>
<h4><b>Session 1: Introduction to the Program (4 hours) </b></h4>
<ul>
<li>How we will work together virtually.</li>
<li>Why write policies and procedures? When are they needed?</li>
<li>Who (should) develop guidelines for writing and using policies and procedures?</li>
<li>The difference between policies, procedures and processes.</li>
<li>How policies and procedures relate to the achievement of strategic goals and organisational values.</li>
</ul>
<h4><b>Session 2: Documentation Hierarchy (4 Hours) </b></h4>
<ul>
<li>Documentation hierarchy: policies, procedures, work instructions and records. </li>
<li>Writing a policy (clearly and concisely).</li>
<li>Writing a procedure (clearly and concisely).</li>
<li>Process mapping.</li>
<li>How much documentation is enough when writing a procedure?</li>
<li>Writing a work instruction.</li>
</ul>
<h4><b>Session 3: How to Ensure Policies and Procedures Stay Current? (4 Hours)</b></h4>
<ul>
<li>Policy and procedure administrator.</li>
<li>Document control.</li>
<li>Approval process.</li>
<li>Distribution and sign off.</li>
<li>Regular update review.  </li>
</ul>
<p></p>

Professional Skills Course (PSC)

Policy Writing

Continuous Professional Development (CPD)

All organizations have policies and procedures that guide how decisions are made and how the work is done in that organization. Professionally written policies and procedures increase organizational accountability and transparency and are fundamental to quality/standards assurance and quality improvement.

Policy & Procedure Writing

London

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Manage project costs</li><li>Consolidate and reuse project plan information</li><li>Exchange project plan data with other applications</li><li>Update a project plan</li><li>Customise Project to meet specific requirements</li></ul><p>' 1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.</strong></p></li><li>Kelly Moreley - TACT</li></ul><ul><li><strong>Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further</strong></li><li>Jenny Price - Acer</li></ul><p>'</p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p>Exchanging Project Plan Data with Other Applications</p><ul><li>Import a list of tasks from Outlook</li><li>Import a Task List from an Excel File</li><li>Create a Custom Import Map</li><li>Export Project Plan Cost Data into Excel</li><li>Save Project Plan Information as a Web Page</li></ul><p>Updating a Project Plan</p><ul><li>Enter Task Progress Information</li><li>View Task Progress</li><li>Split a Task</li><li>Reschedule a Task</li></ul><p>Creating Custom Fields</p><ul><li>Text fields</li><li>Lookup fields</li><li>Calculated fields with the use of formulas and functions</li><li>Inserting Graphical Indicators</li></ul><p>Customizing how you look at data</p><ul><li>Filter Tasks in a Project Plan</li><li>Create a Custom Table</li><li>Create a Custom View</li><li>Copy custom Views and Tables between projects</li></ul><p>Earned value analysis</p><ul><li>Understanding Earned Value Fields</li><li>View Multiple Baselines in a Single Project</li><li>Tracking progress between interim plans</li></ul><p>Creating Custom Reports</p><ul><li>Create a Custom Report</li><li>Modify a Custom Report's Header and Footer</li><li>Add a Picture to a Report</li><li>Modify a Custom Report's Margins</li><li>Print a Custom Report</li></ul><p>Re-using Project Plan Information</p><ul><li>Create a Project Plan Template</li><li>Create a Custom Combination View</li><li>Make Custom Views Available to Other Project Plans</li><li>Share Resources between Projects,</li><li>Create a Master Project Plan with sub projects</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates would have attended the MS Project Introduction course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div>

Microsoft Office Training

Microsoft Project Advanced - In-company (now with trainer led live online classes)

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Identify the components of the Microsoft Project environment</li><li>Create a new project plan</li><li>Create the project schedule</li><li>Use different views to analyse the project plan</li><li>Create, allocate and manage resources in a project plan</li><li>Finalise a project plan</li><li>Track progress</li><li>View and report project plan information</li></ul><p>' 1 year email support service</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Very good course. Learnt a lot. Looking forward to the next level.</strong></p></li><li>Alexandra - CIAL</li></ul><p>'</p><p>1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Introduction to Microsoft Project</strong></p><ul><li>Recap on project management concepts</li><li>Project environment overview</li><li>The 3 databases: Tasks, Resources and Assignments</li><li>Different ways of displaying the Project Plan</li><li>Access Help</li></ul><p><strong>Creating a Project Plan</strong></p><ul><li>Create a New Project Plan</li><li>Project Information</li><li>Create and apply the project calendar</li><li>Defining recurring exceptions to the calendar</li><li>Defining the calendar's work weeks</li><li>Create the Summary tasks</li><li>Create the Work Breakdown Structure</li></ul><p><strong>Task creation and scheduling</strong></p><ul><li>Exploring the Entry Table and its fields</li><li>Task editing and the Task Information window</li><li>Task Durations</li><li>Defining Milestones</li><li>Manual Scheduling vs Automatic Scheduling</li><li>Changing the Task's Calendar</li><li>Create a split in a Task</li><li>Create Task Relationships</li><li>Adding Lag or Lead to a Relationship</li><li>Identifying the Critical Path</li><li>Adding Constraints and Deadlines to Tasks</li><li>Create Recurring Activities</li><li>Adding Notes and links to Tasks</li></ul><p><strong>Managing Resources</strong></p><ul><li>Exploring the Entry Table and its fields</li><li>Resource editing and the Resource Information window</li><li>Resource Types</li><li>Fixed Costs vs Variable Costs</li><li>Adding Resource Costs</li><li>Defining when costs accrue</li><li>Changing the Resource Calendar and Availability</li><li>Project calendar vs Resource and Task Calendar</li><li>Assigning Resources to Tasks</li><li>Effort Driven Scheduling</li><li>Resolving Resource Overallocation</li></ul><p><strong>Tracking the Project Progress</strong></p><ul><li>Setting a Project Baseline</li><li>Entering Actuals</li><li>Different ways of viewing the Progress</li><li>Checking if the Project is on track</li></ul><p><strong>Viewing and Reporting Project Detail</strong></p><ul><li>Adding Tasks to the Timeline and sharing it</li><li>Modifying the Timescale and Zoom level</li><li>Formatting the Gantt View</li><li>Filtering and Grouping Tasks</li><li>Print and Troubleshoot the Gantt View</li><li>Using built-in Reports in Microsoft Project</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>General knowledge of the Windows OS</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Project Introduction - In-company

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Record and edit a Macro</li><li>Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects.</li><li>Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures</li><li>Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope</li><li>Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks</li><li>Create an error handling routine in case things go wrong with VBA code</li></ul><p>' 1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience..</strong></p></li><li>Simon Harper - Lloyd's of London</li></ul><ul><li><p><strong>My learning experience was awesome.</strong></p></li><li>Perdinand Reagan - Subsea7</li></ul><ul><li><p><strong>Very nice and relaxed approach to teaching. Was definitely a good learning experience</strong><strong>.</strong></p></li><li>Jerome Pupe - S5 Agency World</li></ul><ul><li><strong>The Trainer – Very positive + patient + helpful + thorough</strong></li><li>Agnes Souza - Direct Wines</li></ul><p>'</p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Introduction to Macros and VBA</strong></p><ul><li>Introducing Visual Basic for Applications</li><li>Recording a Macro</li><li>Naming conventions for Macro Procedures</li><li>Running a Macro</li><li>Absolute or Relative Cell Referencing</li><li>Saving and Opening Files with Macros</li><li>Making macros always available</li><li>Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes</li><li>Editing a Macro in the Visual Basic Editor</li><li>Understanding the Development Environment</li><li>Customising the Editor</li><li>Tips for General Typing in VBA</li><li>Using Visual Basic Help</li></ul><p><strong>Working with Procedures</strong></p><ul><li>Program Design</li><li>Understanding Modules</li><li>Naming Rules</li><li>Creating a Module</li><li>Understanding Procedures</li><li>Programming Macro Concepts</li><li>Creating a Subroutine</li><li>Creating a Function</li><li>Understanding Arguments</li><li>Exiting Procedures</li><li>Calling Procedures</li></ul><p><strong>Objects, Properties, Methods and Events</strong></p><ul><li>Understanding Objects Properties, Methods, and Events</li><li>Navigating the Object Hierarchy</li><li>Understanding Collections</li><li>Accessing a Member of a Collection</li><li>Understanding Hierarchy</li><li>Using the Object Browser</li><li>Using the With Statement</li><li>Working with Properties</li><li>Working with Methods</li><li>Creating an Event Procedure</li><li>Reserved Macro Names</li></ul><p><strong>Using Expressions, Variables and Intrinsic Functions</strong></p><ul><li>Understanding Expressions and Statements</li><li>Declaring Variables</li><li>Understanding Data Types</li><li>Determining the Value of Variables</li><li>Working with Variable Scope</li><li>Using Built-in VBA Functions</li><li>Understanding Constants</li><li>Using Message Boxes</li><li>Controlling the Answer to a Message Box</li><li>Using Input Boxes</li><li>Declaring and Using Object Variables</li></ul><p><strong>Controlling Program Execution</strong></p><ul><li>Understanding Control-of-Flow Structures</li><li>Using the If...End If Decision Structures</li><li>Nested If Statements</li><li>Using the Select Case ... End Select Structure</li><li>Using the Do ... Loop Structure</li><li>Using the For ... Next Structure</li><li>Using the For Each ... Next Structure</li><li>Guidelines for Use of Control-of-Flow Structures</li></ul><p><strong>Debugging and Handling Errors</strong></p><ul><li>Understanding Errors</li><li>Using Debugging Tools</li><li>Setting Breakpoints and Using Break Mode</li><li>Stepping Through Code</li><li>Trapping Errors with the On Error Statement</li><li>Understanding the Err Object</li><li>Working with Inline Error Handling</li><li>Writing an Error-Handling Routine</li></ul><p><strong>Working with Forms and Controls</strong></p><ul><li>Understanding UserForms</li><li>Creating a Form</li><li>Displaying and Removing a Form</li><li>Aligning and Sizing Controls</li><li>Using the Toolbox</li><li>Working with a Form's Properties, Methods, and Events</li><li>Working with Form and Control Properties, Methods and Event</li><li>Setting the Tab Order</li><li>Populating a Control</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Advanced course.</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Macros & VBA - In-company

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Price</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&pound;750 inc VAT</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Finance options</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In Company training - &pound;750 for groups of up to 8 delegates.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Discounts for Nonprofits/Charities...&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Study method</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">On-site</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2 days, Full-time</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Qualification</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">No formal qualification</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certificates</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Certificate of completion - Free</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Additional info</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tutor is available to students</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Objectives</strong></p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">At the end of this course you will be able to:</p><ul style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><li fr-original-style="" style="box-sizing: border-box;">Identify the components of the Microsoft Project environment</li><li fr-original-style="" style="box-sizing: border-box;">Create a new project plan</li><li fr-original-style="" style="box-sizing: border-box;">Create the project schedule</li><li fr-original-style="" style="box-sizing: border-box;">Use different views to analyse the project plan</li><li fr-original-style="" style="box-sizing: border-box;">Create, allocate and manage resources in a project plan</li><li fr-original-style="" style="box-sizing: border-box;">Finalise a project plan</li><li fr-original-style="" style="box-sizing: border-box;">Track progress</li><li fr-original-style="" style="box-sizing: border-box;">View and report project plan information</li></ul><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">&#39; 1 year email support service</p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Customer Feedback</strong></em></p><ul style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Very good course. Learnt a lot. Looking forward to the next level.</strong></p></li><li fr-original-style="" style="box-sizing: border-box;">Alexandra - CIAL</li></ul><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">1 year email support service</p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">Take a closer look at the&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">consistent excellent feedback from our growing corporate clients</strong>&nbsp;visiting our site&nbsp;<em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ms-officetraining co uk</strong></em></p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">With more than 20 years experience, we deliver courses on all levels of the Desktop version of&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;public, one to one, tailored and bespoke courses.</strong></p><ul style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Our competitive rates&nbsp;start from &pound;550.00 per day of training</strong></li></ul><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Tailored training courses:</strong></p><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><section style="color: rgb(15, 21, 26); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(15, 21, 26);"><h2 fr-original-style="" style="box-sizing: border-box;">Description</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Introduction to Microsoft Project</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Recap on project management concepts</li><li fr-original-style="" style="box-sizing: border-box;">Project environment overview</li><li fr-original-style="" style="box-sizing: border-box;">The 3 databases: Tasks, Resources and Assignments</li><li fr-original-style="" style="box-sizing: border-box;">Different ways of displaying the Project Plan</li><li fr-original-style="" style="box-sizing: border-box;">Access Help</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Creating a Project Plan</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Create a New Project Plan</li><li fr-original-style="" style="box-sizing: border-box;">Project Information</li><li fr-original-style="" style="box-sizing: border-box;">Create and apply the project calendar</li><li fr-original-style="" style="box-sizing: border-box;">Defining recurring exceptions to the calendar</li><li fr-original-style="" style="box-sizing: border-box;">Defining the calendar&#39;s work weeks</li><li fr-original-style="" style="box-sizing: border-box;">Create the Summary tasks</li><li fr-original-style="" style="box-sizing: border-box;">Create the Work Breakdown Structure</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Task creation and scheduling</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Exploring the Entry Table and its fields</li><li fr-original-style="" style="box-sizing: border-box;">Task editing and the Task Information window</li><li fr-original-style="" style="box-sizing: border-box;">Task Durations</li><li fr-original-style="" style="box-sizing: border-box;">Defining Milestones</li><li fr-original-style="" style="box-sizing: border-box;">Manual Scheduling vs Automatic Scheduling</li><li fr-original-style="" style="box-sizing: border-box;">Changing the Task&#39;s Calendar</li><li fr-original-style="" style="box-sizing: border-box;">Create a split in a Task</li><li fr-original-style="" style="box-sizing: border-box;">Create Task Relationships</li><li fr-original-style="" style="box-sizing: border-box;">Adding Lag or Lead to a Relationship</li><li fr-original-style="" style="box-sizing: border-box;">Identifying the Critical Path</li><li fr-original-style="" style="box-sizing: border-box;">Adding Constraints and Deadlines to Tasks</li><li fr-original-style="" style="box-sizing: border-box;">Create Recurring Activities</li><li fr-original-style="" style="box-sizing: border-box;">Adding Notes and links to Tasks</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Managing Resources</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Exploring the Entry Table and its fields</li><li fr-original-style="" style="box-sizing: border-box;">Resource editing and the Resource Information window</li><li fr-original-style="" style="box-sizing: border-box;">Resource Types</li><li fr-original-style="" style="box-sizing: border-box;">Fixed Costs vs Variable Costs</li><li fr-original-style="" style="box-sizing: border-box;">Adding Resource Costs</li><li fr-original-style="" style="box-sizing: border-box;">Defining when costs accrue</li><li fr-original-style="" style="box-sizing: border-box;">Changing the Resource Calendar and Availability</li><li fr-original-style="" style="box-sizing: border-box;">Project calendar vs Resource and Task Calendar</li><li fr-original-style="" style="box-sizing: border-box;">Assigning Resources to Tasks</li><li fr-original-style="" style="box-sizing: border-box;">Effort Driven Scheduling</li><li fr-original-style="" style="box-sizing: border-box;">Resolving Resource Overallocation</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Tracking the Project Progress</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Setting a Project Baseline</li><li fr-original-style="" style="box-sizing: border-box;">Entering Actuals</li><li fr-original-style="" style="box-sizing: border-box;">Different ways of viewing the Progress</li><li fr-original-style="" style="box-sizing: border-box;">Checking if the Project is on track</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Viewing and Reporting Project Detail</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Adding Tasks to the Timeline and sharing it</li><li fr-original-style="" style="box-sizing: border-box;">Modifying the Timescale and Zoom level</li><li fr-original-style="" style="box-sizing: border-box;">Formatting the Gantt View</li><li fr-original-style="" style="box-sizing: border-box;">Filtering and Grouping Tasks</li><li fr-original-style="" style="box-sizing: border-box;">Print and Troubleshoot the Gantt View</li><li fr-original-style="" style="box-sizing: border-box;">Using built-in Reports in Microsoft Project</li></ul></section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><h2 fr-original-style="" style="box-sizing: border-box;">Who is this course for?</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p></section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;">Requirements</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">General knowledge of the Windows OS</p></section><section style="color: rgb(15, 21, 26); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);"><h2 fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 fr-original-style="" style="box-sizing: border-box;">Career path</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">80 percent of job openings require spreadsheet and word-processing software skills</p></section>

Microsoft Project Introduction/Intermediate - In-company

General admission

<p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Customise tables and charts</li><li>Customise formatting with styles and themes</li><li>Modify pictures in a document</li><li>Create customised graphic elements</li><li>Insert content using Quick Parts</li><li>Control text flow</li><li>Use templates to automate document creation</li><li>Perform mail merges</li><li>Use macros to automate common tasks</li></ul> <p>'1 year email support service</p> <p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p> <p><em><strong>Customer Feedback</strong></em></p> <ul> <li> <p><strong>Excelent enviroment for training. Tahnk you.</strong></p> </li><li>Jenny Price - ACER</li></ul> <p>'</p> <p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p> <p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p> <ul> <li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul> <p><strong><strong>Tailored training courses:</strong></strong></p> <p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p>Working with Tables and Charts</p> <ul> <li>Sort Table Data</li><li>Control Cell Layout</li><li>Perform Calculations in a Table</li><li>Create a Chart</li></ul> <p>Customising Formats Using Styles and Themes</p> <ul> <li>Create and Modify Text Styles</li><li>Create Custom List or Table Styles</li><li>Apply Document Themes</li></ul> <p>Using Images in a Document</p> <ul> <li>Resize an Image</li><li>Adjust Image Appearance</li><li>Integrate Pictures and Text</li><li>Insert and Format Screenshots</li><li>Use the Snipping tool</li></ul> <p>Creating Custom Graphic Elements</p> <ul> <li>Create Text Boxes and Pull Quotes</li><li>Draw Shapes</li><li>Add WordArt and Other Text Effects</li><li>Create Complex Illustrations with SmartArt</li></ul> <p>Inserting Content Using Quick Parts</p> <ul> <li>Insert Building Blocks</li><li>Create and Modify Building Blocks</li><li>Insert Fields Using Quick Parts</li></ul> <p>Controlling Text Flow</p> <ul> <li>Control Paragraph Flow</li><li>Insert Section Breaks</li><li>Insert Columns</li><li>Link Text Boxes to Control Text Flow</li></ul> <p>Using Templates</p> <ul> <li>Create a Document Using a Template</li><li>Create a Template</li></ul> <p>Using Mail Merge</p> <ul> <li>The Mail Merge Features</li><li>Merge Envelopes and Labels</li><li>Create a Data Source Using Word</li></ul> <p>Using Macros</p> <ul> <li>Automate Tasks Using Macros</li><li>Create a Macro</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Preferably, delegates should have attended the Word Introduction course.</p> 
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p> <p>80 percent of job openings require spreadsheet and word-processing software skills</p> 
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Word Intermediate - In-company (now with live online classes)

<p><strong>Course Objectives</strong></p><p>This course aims to provide delegates with a foundation for Excel knowledge and skills.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Very professional and well mannered, fun and pleasant at the same time. I learnt a lot</strong></li><li>Carolina Foster - CNN</li></ul><ul><li><strong>Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all.</strong></li><li>Laura Smith - James Grant</li></ul><ul><li><strong>Great course and excellent trainer. Thanks</strong></li><li>Tracy Preston - Western Power Distribution</li></ul><p>1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>What is Excel?</strong></p><p><strong>The Excel Interface</strong></p><ul><li>Ribbon, Tabs and Groups</li><li>Microsoft Office Backstage view</li></ul><p><strong>Working with Workbooks</strong></p><ul><li>Create a blank Workbook</li><li>Create a Workbook using a Template</li><li>Opening and saving Files</li></ul><p><strong>Working with worksheets</strong></p><ul><li>Worksheet navigation</li><li>Select one or multiple Worksheets</li><li>Insert, Move, Copy or Delete a Worksheet</li></ul><p><strong>Working with Cells, Rows &amp; Columns</strong></p><ul><li>Cell References</li><li>How to select cells or ranges</li><li>Different types of data</li><li>Move, Copy and Delete cells</li><li>Pasting Options</li><li>Find and Replace</li><li>Working with Rows and Columns</li></ul><p><strong>Overview of formulas in Excel</strong></p><ul><li>Autocalculation</li><li>The parts of an Excel formula</li><li>Using calculation operators in Excel formulas</li><li>The difference between Absolute, Relative and Mixed references</li><li>Using Excel functions; Sum, Average, Max and Min</li></ul><p><strong>Cell Formatting</strong></p><ul><li>Font Format options</li><li>Number Format options</li><li>Change the Fill and Borders</li><li>Cell Alignment</li></ul><p><strong>An Introduction to Charts</strong></p><ul><li>Create a simple Chart</li><li>Format your chart</li></ul><p><strong>Page Layout and Print</strong></p><ul><li>Page Layout and Page Break View</li><li>Change the Page Orientation</li><li>Set Page Margins</li><li>Headers and Footers in a worksheet</li><li>Print a worksheet or workbook</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>All users who want to master the main features of Microsoft Excel</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>General knowledge of the Windows OS</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Introduction - In-company

<p><strong>Course Objectives</strong></p><p>The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data.</p><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great.</strong></p></li><li>Kelly Moreley - TACT</li></ul><ul><li><strong>Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys.</strong></li><li>Jenny Price - Acer</li></ul><p>1 year email support service</p><p>Take a look at the <strong>consistent excellent feedback from our corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.</p><p><strong><strong>Tailored training courses:</strong></strong></p><p>In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Recap on Excel formulas and calculations</strong></p><ul><li>Overview of formulas in Excel</li><li>Relative, Absolute and Mixed cell references</li></ul><p><strong>Group editing worksheets</strong></p><p><strong>Autofill and Flash Fill</strong></p><p><strong>Changing Excel’s environment Options</strong></p><ul><li>Changing the default number of sheets</li><li>Creating an Autofill Custom List</li><li>Adding tools to the Quick Access Toolbar</li></ul><p><strong>Mastering Excel Tables</strong></p><ul><li>Introducing Excel Tables</li><li>Formatting a Table</li><li>Creating Calculated Columns</li><li>Using Slicers to filter your data</li><li>Using Totals to get statistics out of your data</li><li>Removing duplicates</li><li>Converting Tables back to normal Ranges</li></ul><p><strong>Using names Ranges</strong></p><ul><li>In Excel formulas</li><li>As a way of navigating through the workbook</li></ul><p><strong>Advanced Formulas</strong></p><ul><li>Simple IF examples</li><li>Using IF to check if a cell is blank</li><li>Nested IFs</li><li>VLOOKUP</li><li>HLOOKUP</li><li>Text Functions</li><li>Date Functions</li></ul><p><strong>Conditional formatting</strong></p><ul><li>Apply Conditional Formatting</li><li>Customising Conditional Formatting</li><li>Using Icons in Conditional Formatting</li><li>Using Formulas to conditionally format cells</li></ul><p><strong>Linking spreadsheets and workbooks</strong></p><ul><li>Making a reference to another worksheet</li><li>Making a reference to another workbook</li><li>Editing links</li><li>Troubleshooting links</li></ul><p><strong>Analysing databases</strong></p><ul><li>Quick analysis</li><li>Sorting a database</li><li>Apply filters to a database</li><li>Advance filter</li><li>Sorting and Filtering by Conditional Formats</li></ul><p><strong>Charts</strong></p><ul><li>Analyse trends in data using Sparklines</li><li>Creating charts from start to finish</li><li>Exploring the different Chart Types</li><li>Apply Chart Styles</li><li>Formatting Chart Elements</li><li>Filtering Charts by Series or Categories</li><li>Adding a Trendline to a Chart</li><li>Create a Chart Template</li></ul><p><strong>Attaching security to a spreadsheet and workbook</strong></p><ul><li>Protect Cells</li><li>Protect Structure of worksheets</li><li>Protect a Workbook by adding passwords</li></ul><p><strong>Introduction to Pivot Tables</strong></p><ul><li>What are Pivot Tables?</li><li>Using recommended pivot tables to analyse your data</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>For those who want to explore in more detail formulas and functions, data analysis and data presentation.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates would have attended the Excel Introduction course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Intermediate - In-company

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Work with advanced lookup and reference functions</li><li>Create macros to automate common tasks</li><li>Use advanced techniques to analyse data</li><li>Create PivotTables and PivotCharts</li><li>Work with data validation tools</li><li>Import and export data</li></ul><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.</strong></p></li><li>Marving Lopez - AM Best Europe</li></ul><ul><li><strong>Pedro was excellent. Very knowledgeable, clear and great rapport with class.</strong></li><li>Darren Barkey - Direct Wines</li></ul><ul><li><strong>Great content and learnt a lot. Really enjoyable :)</strong></li><li>Kristie-Lee Ryan - Stirling Ackroyd</li></ul><p>1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p>Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.</p><p><strong>Advanced Functions</strong></p><ul><li>COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL</li><li>IF, OR, AND, IFERROR</li><li>VLOOKUP to lookup Exact Values and Approximate values</li><li>MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET</li></ul><p><strong>Analysing Data</strong></p><ul><li>PMT function to calculate a monthly payment of a loan</li><li>What If Analysis using Goal Seek</li><li>Use scenarios to consider many different variables</li><li>Using Solver Add-in to optimize variables</li></ul><p><strong>PivotTables</strong></p><ul><li>Create a PivotTable to analyse worksheet data</li><li>Add or remove fields in a PivotTable</li><li>Change the data source for a PivotTable</li><li>Working with external data sources</li><li>Using different Statistical Functions</li><li>Calculate a Running Total, % of Grant Total, Difference From…</li><li>Using the Slicer and Timeline to filter the PivotTable</li><li>Using Filters in a PivotTable</li><li>Group by Date, Auto Group by ranges of values, Custom Group</li><li>Create a PivotChart</li><li>The GETPIVOTDATA function</li></ul><p><strong>Formula auditing</strong></p><ul><li>Precedents and dependents</li><li>Error checking</li><li>Watch a formula and its result by using the Watch Window</li><li>Evaluate a nested formula one step at a time</li></ul><p><strong>Data Validation</strong></p><ul><li>Number Validation</li><li>Data List Validation</li><li>Message Prompts and Alerts</li><li>Conditional Data Validation</li><li>Data Validation Errors</li></ul><p><strong>Consolidation</strong></p><ul><li>Consolidate data by position</li><li>Consolidate data by category</li><li>Use a formula to consolidate data</li></ul><p><strong>Outline (group) data in a worksheet</strong></p><ul><li>Create an outline of rows</li><li>Create an outline of columns</li><li>Copy outlined data</li><li>Hide or remove an outline</li></ul><p><strong>Connect external data to your workbook</strong></p><ul><li>Using the Power Query Editor to import data</li><li>From Text and CSV, From Access, From Web, From another Workbook</li><li>Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.</li><li>Deleting Applied Steps</li><li>Refreshing your data</li></ul><p><strong>Working with Form Controls; Buttons, Option Buttons and Scroll Bars</strong></p><p><strong>Introduction to Macros</strong></p><ul><li>Change Macro Security settings</li><li>How to Record a macro</li><li>Some Macro Examples</li><li>Delete a macro</li><li>Edit the macro to view the VBA code</li><li>Copy part of a macro to create another macro</li><li>Assign a macro to a button</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Intermediate course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Advanced - In-company

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and who has the responsibility to achieve and improve the availability and manageability of the data centre.</p>Overview<p>After completion of the course the participant will be able to:? Choose an optimum site for mission-critical data centre based on current and future needs? Describe all components that are important for high availability in a data centre and how to effectively setup the data centre? Name and apply the various industry standards? Describe the various technologies for UPS, fire suppression, cooling, monitoring systems, cabling standards, etc, and to select and apply them effectively to cost-efficiently enhance the high-availability of the data centre.? Review the electrical distribution system to avoid costly downtime? Enhance cooling capabilities and efficiency in the data centre by using existing and new techniques and technologies for the increased cooling requirements of the future? Design a highly reliable and scalable network architecture and learn how to ensure installers apply proper testing techniques? Create effective maintenance contracts with equipment suppliers ensuring the best return on investment? Setup effective data centre monitoring ensuring the right people get the right message? Ensure proper security measures, both procedural and technical, are established to safeguard your company's valuable information in the data centre</p><p>The course will address how to setup and improve key aspects such as power, cooling, security, cabling, safety, etc., to ensure a high available data centre. It will also address key operations and maintenance aspects.</p></div><div id="course-pills-2"><h4>The Data Centre, it?s Importance and Causes for Downtime</h4><h4>Data Centre Standards and Best Practices</h4><h4>Data Centre Location, Building and Construction</h4><ul><li>Selecting appropriate sites and buildings and how to avoid pitfalls<br />Various components of an effective data centre and supporting facilities setup</li></ul><h4>Raised Floor/Suspended Ceiling</h4><ul><li>Uniform, concentrated and rolling load definitions<br />Applicable standards<br />Raised Floor guidelines<br />Signal Reference Grid, grounding of racks<br />Disability act and regulations<br />Suspended ceiling usage and requirements</li></ul><h4>Light</h4><ul><li>Standards<br />Light fixture types and placement<br />Emergency lighting, Emergency Power Supply (EPS)</li></ul><h4>Power Infrastructure</h4><ul><li>Power infrastructure layout from generation to rack level<br />ATS and STS systems<br />Redundancy levels and techniques<br />Three-phase and single-phase usage<br />Power distribution options within the computer room<br />Power cabling versus bus bar trunking<br />Bonding versus grounding<br />Common Mode Noise and isolation transformers<br />Distribution boards, form factors and IP-protection grades<br />Power quality guidelines<br />Real power versus apparent power<br />How to size and calculate load in the data centre Generators<br />Static and dynamic UPS systems, selection criteria, how they operate and energy efficiency option<br />Battery types, correct selection and testing<br />Thermo-graphics</li></ul><h4>Electro Magnetic Fields</h4><ul><li>Electrical fields and magnetic fields definitions and units of measurements<br />Sources of EMF<br />Effects of EMF on human health and equipment<br />(H)EMP<br />Standards<br />EMF shielding solutions</li></ul><h4>Equipment Racks</h4><ul><li>Rack standards, properties and selection criteria<br />Security considerations<br />Power rail/strip options</li></ul><h4>Cooling Infrastructure</h4><ul><li>Temperature and humidity recommendations<br />Cooling measurement units and conversion rates<br />Sensible and latent heat definitions<br />Differences between comfort and precision cooling<br />Overview of different air conditioner technologies<br />Raised floor versus non-raised floor cooling<br />Placement of air conditioner units and limitations to be observed<br />Supplemental cooling options<br />Cold aisle/hot aisle containment</li></ul><h4>Water Supply</h4><ul><li>Importance of water supply and application areas<br />Backup water supply techniques</li></ul><h4>Designing a Scalable Network Infrastructure</h4><ul><li>The importance of a Structured Cabling System<br />Planning considerations<br />Copper and Fiber cable technology and standards<br />ANSI/TIA-942 Cabling hierarchy and recommendations<br />Testing and verification<br />SAN storage cabling<br />Network redundancy<br />Building-to-building connectivity<br />Network monitoring system requirements</li></ul><h4>Fire Suppression</h4><ul><li>Standards for fire suppression<br />Detection systems<br />Various total flooding fire suppression techniques and systems, their benefits and disadvantages<br />Handheld extinguishers<br />Signage and safety<br />Regulatory requirements and best practices</li></ul><h4>Data Centre Monitoring</h4><ul><li>Data centre monitoring requirements<br />EMS versus BMS<br />Water leak detection systems<br />Notification options and considerations</li></ul><h4>Operational Security and Safety Practices</h4><ul><li>Data centre security layers<br />Physical, infrastructure and organisational security<br />Safety measures and essential signage</li></ul><h4>Labelling</h4><ul><li>Choosing a labelling scheme<br />Recommended labelling practices<br />Network labelling</li></ul><h4>Documentation</h4><ul><li>How to setup proper documentation<br />Document management policies and procedures</li></ul><h4>Cleaning</h4><ul><li>Cleaning practices for the data centre</li></ul><h4>MTBF/MTTR</h4><ul><li>Standards and definitions<br />Calculation models<br />The ?real? value</li></ul><h4>Maintenance Contracts/SLA/OLA</h4><h4>EXAM: Certified Data Centre Professional</h4></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Certified Data Centre Professional (CDCP) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Certified Data Centre Professional (CDCP) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

IT Certifications

Construction Design & Management (CDM)

Certified Cloud Security Professional (CCSP)

AWS Certified Cloud Practitioner

Certified in Data Protection (CDP)

Certified Cyber Professional (CCP)

Certified Data Centre Professional (CDCP)

<h1 id="isPasted" style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Online MHFA England Adult Mental Health First Aid Course.&nbsp;</h1><div fr-original-style="" style="box-sizing: border-box;"><a href="https://www.mindmapswellbeing.com/brochure-request/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Download brochure for course details here.</a><a href="https://www.mindmapswellbeing.com/_webedit/uploaded-files/All%20Files/Online%20Mental%20Health%20First%20Aid.pdf" rel="noopener noreferrer" target="_blank" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">&nbsp;</a>&nbsp;</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. &nbsp;The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. &nbsp;As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation&#39;s courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. &nbsp;As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. &nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Our fee is &pound;300pp Groups of 5+ contact <a href="mailto:info@mindmapswellbeing.com" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">info@mindmapswellbeing.com</a>&nbsp;for reduced group fees.&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Live instructor led sessions;&nbsp;</strong></div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">10:00 &ndash; 12:30 &amp; 14:30 &ndash; 17:00 both days&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Individual learning modules around these times. You will gain access to this on the Friday before your course start date.</div><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;">Why choosing Mindmaps Wellbeing is a good choice for your training.</u></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The MHFA England RRP is &pound;325pp, our rate is &pound;300pp and our fee includes:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Instructor led training sessions over two days</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Course Manual</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Workbook</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Handy Cue Card</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ MHFAider Certificate upon completion</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Your instructors are <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Registered Mental Health Nurses and Healthcare Educators</strong> (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Access to our online MHFAider peer support groups moderated by the instructor team.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Advanced Delegate Plan &ndash; This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">For a little extra:&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Quarterly Facilitated MHFAider Forum &ndash; to provide ongoing expert support and guidance.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✅ Organisational MINDWELL Companion tailored for your workplace / organisation.</p>

Online MHFA England Adult Mental Health First Aid Course. 
Download brochure for course details here.  This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation's courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. Our fee is £300pp Groups of 5+ contact info@mindmapswellbeing.com for reduced group fees. Live instructor led sessions; 10:00 – 12:30 & 14:30 – 17:00 both days Individual learning modules around these times. You will gain access to this on the Friday before your course start date.
Why choosing Mindmaps Wellbeing is a good choice for your training.
The MHFA England RRP is £325pp, our rate is £300pp and our fee includes:
✅ Instructor led training sessions over two days
✅ Course Manual
✅ Workbook
✅ Handy Cue Card
✅ MHFAider Certificate upon completion
Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:
✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).
✅ Access to our online MHFAider peer support groups moderated by the instructor team.
✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.
✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.
 
For a little extra: 
✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. 
✅ Organisational MINDWELL Companion tailored for your workplace / organisation.

Mindmaps Wellbeing

Health & Wellbeing

Occupational Health & Wellbeing

Mental Health

Accredited Mental Health First Aid

Mental Health At Work

Mental Health Nurse

Online MHFA England mental health first aid course delivered by Registered Mental Health Nurses from Mindmaps Wellbeing. 

Why choosing Mindmaps Wellbeing is a good choice for your mental health training.
The MHFA England RRP is £325pp, our rate is £300pp and our fee includes:
✅ Instructor led training sessions over two days 
✅ Course Manual
✅ Workbook
✅ Handy Cue Card
✅ MHFAider Certificate upon completion
Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:

✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).

✅ Access to our online MHFAider peer support groups moderated by the instructor team.

✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.

✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.

For a little extra: 

✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. 

✅ Organisational MINDWELL Companion tailored for your workplace / organisation.


MHFA England Mental Health First Aid

<p dir="ltr" id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Overview</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Dive into our Organisational Planning &amp; Ethics course, tailored for the evolving job market. With technology and healthcare jobs booming, over 4.7 million new opportunities will open up by 2032 in the USA. This course teaches you to set goals, use resources well, and adapt to changes.&nbsp;</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Learn why ethics matter in building trust, improving your company&#39;s image, and making workplaces better. You&#39;ll get ready to lead businesses to success. Make positive impacts in the society. From marketing to crisis management and new technologies, become a leader for the future.&nbsp;</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Get set for a dynamic business world.</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><br fr-original-style="" style="box-sizing: border-box;"></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Outcomes</strong></span></p><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;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Understand the principles of organisational ethics.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Develop a comprehensive marketing plan.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Identify key elements of effective marketing strategies.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Evaluate strategies for minimising environmental damage.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Utilize new technologies for organisational enhancement.</span></p></li></ul><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Description</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explore the dynamic world of Organisational Planning &amp; Ethics through our comprehensive course. It is designed for those aiming to make a big impact in the modern business world.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">This course delves deep into essential skills and knowledge. Learn how to create robust marketing plans. By mastering the art of crisis management, we guide you every step of the way.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Learn how to minimise environmental damage. Leverage the latest technologies to drive organisational success. Dive into the core elements of marketing. Discover the significance of organisational ethics in shaping a positive company culture.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">This course prepares you for future challenges. It empowers you to lead with confidence and integrity in a changing job market. Get ready to transform your career and make a lasting impression in the world of business.</span></p><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who is this course for?</strong></span></p><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;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Professionals seeking to enhance organisational ethics and planning.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Individuals interested in pursuing careers in marketing and strategic management.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Students looking to gain practical insights into modern business practices.</span></p></li></ul><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Career Path</strong></span></p><ol 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;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Marketing Manager: Expected yearly salary of $70,000 - $150,000.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Environmental Consultant: Expected yearly salary of $50,000 - $90,000.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Crisis Management Specialist: Expected yearly salary of $60,000 - $120,000.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Strategic Planning Analyst: Expected yearly salary of $80,000 - $140,000.</span></p></li></ol>

Course Cloud

Organisation

Explore the dynamic world of Organisational Planning & Ethics through our comprehensive course. It is designed for those aiming to make a big impact in the modern business world.

Organisational Planning & Ethics

Reading

Nottingham

Dickson Training Ltd

First Line Management Course

Classroom Course

Online Course

Oxford

Are you looking to Scale with Purpose AND Grow the Value of your business?

Join us for our FREE world-renowned SCALING UP Business Growth Workshop to learn the 7 tips (at least!) on how to Scale with Purpose.
Scale your business and accelerate profitable growth using the time-tested and results-driven Scaling Up methodology. 
We will introduce you to our proven systems and tools which have successfully enabled over 40,000 business leaders, owners and their leadership teams to achieve sustainable growth. You'll learn the keys to PEOPLE, STRATEGY, EXECUTION AND CASH.
Work smarter, not harder. Scale faster and avoid the pitfalls

What: A FREE Scaling Up event to help you understand how to scale with purpose and grow your value
Why: Clarity - it's about taking time out to plan. To create the plan for your next 90 days and for 2025

Where: Online 
When: Wednesday November 13th 2024 2pm-3.30pm (UK)
This isn't just a seminar where you sit and absorb - you will be working ON your business so you go away with renewed clarity about what to do next...

Ready to Get Down to Business and Scale-Up?
ALIGN - Get faster results with less effort by developing organisational clarity and accountability.
ACCELERATE - Develop a strategic advantage over the competition. Position your brand as a market leader.
ADVANCE - Using the Rockefeller Habits 2.0 Scaling Up Coaches have enabled companies to dominate their industries and make a more significant difference in the world.
Who should attend?
This workshop is specially designed for anyone who leads a business, whether you do this alone or within a leadership or management team. 
You should consider registering whether you are a CEO, CFO, entrepreneur or member of the leadership team. It is incredibly useful to bring your group to this event.
Those who attend this Scaling Up event will gain invaluable insight on how they can get back to business and advance their business growth.
What you will learn 
We will focus on the four critical decisions all businesses face - so you can get back to business:
Scaling Up PEOPLE
The Leaders: the FACE and PACE of the company
Align your team around core values and purpose
Create culture that works
Scaling Up STRATEGY
The Core: Values, Purpose, and Competencies
The 7 strata of Strategy
The One Page Strategic Plan
Scaling Up EXECUTION
The Priority: focus, finish lines and fun
The Meeting Rhythm: the heartbeat of the organization.
Systematise It
Grow the value of your business
What you will go away with
A plan – for the next 90 days and for the coming year
The ability to hit the ground running throughout 2025 confident you know what your whole team are doing
Time to think –  time out of the office – strategic thinking time
The book – Scaling up - revised edition (2022)
Cadence – build cadence and rhythm into your year… annual, monthly and quarterly - this is the start
Our Proven OPSP template
A system for building your business
Course Materials
Materials provided on the day of the workshop include:
• A detailed workbook with information and examples of the concepts presented
• A one-page strategic plan and other actionable tools to help grow your business.

Ignium Consulting Ltd

Strategic Planning

Business Development

Business Strategy

Leadership Development

Business & Management

Business Accelerator

Are you looking to Scale with Purpose AND Grow the Value of your business?

Join us for our FREE world-renowned SCALING UP Business Growth Workshop to learn the 7 tips (at least!) on how to Scale with Purpose.

Scale your business and accelerate profitable growth using the time-tested and results-driven Scaling Up methodology. 

We will introduce you to our proven systems and tools which have successfully enabled over 40,000 business leaders, owners and their leadership teams to achieve sustainable growth. You'll learn the keys to PEOPLE, STRATEGY, EXECUTION AND CASH.

Work smarter, not harder. Scale faster and avoid the pitfalls


What: A FREE Scaling Up event to help you understand how to scale with purpose and grow your value

Why: Clarity - it's about taking time out to plan. To create the plan for your next 90 days and for 2025

Where: Online 

When: Wednesday November 13th 2024 2pm-3.30pm (UK)

This isn't just a seminar where you sit and absorb - you will be working ON your business so you go away with renewed clarity about what to do next...



Learn The 7 Key Tips To Scaling Your Business in 2025 and Beyond

Early Bird (Before November 10th)

Last Minute November Bookings

Hayes

Research Quality Association

Practical Approach to Auditing Systems and Processes

RQA Member

Non Member

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">This masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook including:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">A deep dive into the six steps of the DEI framework&nbsp;<ol style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">DEI Strategy</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Leadership commitment</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Recruitment and hiring of diverse talent</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">inclusive performance management</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">equitable and inclusive organisational culture</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">marketplace and community impact</li></ol></li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Measuring DEI using a scorecard</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">ISO audit - how to prepare for and conduct it</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">The success factors of inclusive culture change&nbsp;</li><li id="isPasted" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Project management techniques and best practice</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">A change communications toolkit</li></ul><p id="isPasted" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 18px; color: rgb(254, 114, 53); box-sizing: border-box;" fr-original-style="font-size: 18px; color: rgb(254, 114, 53);">Who is this learning for?</span></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Diversity and inclusion leads and practitioners</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">HR professionals tasked with diversity and inclusion within their remit</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Managers and leaders looking to develop an inclusive culture</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(254, 114, 53); font-size: 18px; box-sizing: border-box;" fr-original-style="color: rgb(254, 114, 53); font-size: 18px;">What type of learning is this?</span></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Small group learning allows lots of time to focus on the &#39;doing&#39; as well as on learning</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Global cohorts so there is a greater opportunity to learn in a cross-cultural context</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Action learning so you can ask questions, engage with others and get feedback in the moment</li><li id="isPasted" style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Facilitated as an in-person event but also available as a virtual offer</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(254, 114, 53); font-size: 18px; box-sizing: border-box;" fr-original-style="color: rgb(254, 114, 53); font-size: 18px;">What will this do for you?</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">You won&rsquo;t have to continue to rely on hope and luck as a strategy to achieve success. We will work on all the aspects that are introduced in The DEI Playbook to:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Give you the tools to help you make the most effective decisions</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Show how you can implement changes that are long-lasting</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Provide practical guidance and support x1 individual support and implementation session (more sessions can be added for a bonus fee after the main event)</li></ul><p id="isPasted" style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span style="color: rgb(51, 51, 51); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51); font-size: 14px;">This solution&nbsp;</span><span data-key="202" style="color: rgb(51, 51, 51); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51); font-size: 14px;">is developed by licensed and accredited practitioners with practical business experience.</span></p><span style="color: rgb(51, 51, 51); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51); font-size: 14px;">

</span><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><span data-key="204" style="color: rgb(51, 51, 51); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51); font-size: 14px;">On completion, a certificate of attendance will be issued to all participants towards CPD (Continuous Professional Development).</span></p>

This masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook including:
A deep dive into the six steps of the DEI framework 
DEI Strategy
Leadership commitment
Recruitment and hiring of diverse talent
Inclusive performance management
Equitable and inclusive organisational culture
Marketplace and community impact
Measuring DEI using a scorecard
ISO audit - how to prepare for and conduct it
The success factors of inclusive culture change
A change communications toolkit
Project management techniques and best practice
Who is this learning for?
Diversity and inclusion leads and practitioners
HR professionals tasked with diversity and inclusion within their remit
Managers and leaders looking to develop an inclusive culture
What type of learning is this?
Small group learning allows lots of time to focus on the 'doing' as well as on learning
Global cohorts so there is a greater opportunity to learn in a cross-cultural context
Action learning so you can ask questions, engage with others and get feedback in the moment
Facilitated as an in-person event but also available as a virtual offer
What will this do for you?
You won’t have to continue to rely on hope and luck as a strategy to achieve success. We will work on all the aspects that are introduced in The DEI Playbook to:
Give you the tools to help you make the most effective decisions
Show how you can implement long-lasting changes
Provide practical guidance and support x1 individual support and implementation session (more sessions can be added for a bonus fee after the main event)
This solution is developed by licensed and accredited practitioners with practical business experience.
On completion, a certificate of attendance will be issued to all participants towards CPD (Continuous Professional Development).

Starling

Equity & Diversity

Leadership

Organizational Development

Professional Development

Diversity & Inclusion

This one day masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook and is aimed at anyone tasked with launching and implementing diversity and inclusion within their organisation. 

DEI Masterclass - Bringing The DEI Playbook To Life!

DEI Masterclass ticket

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">A one-day course to help you understand the real estate sector, its characteristics and its importance to the general economy. This course will help anyone supporting or moving into the sector with the knowledge and tools to communicate effectively with real estate professionals. By the end of the course delegates will have gained key skills in Real Estate Investment strategy and Analytics. They will also become familiar with the players, structure, general terminology and overall needs of Real Estate.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn what is Real Estate and why it is different from other asset classes</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Get to grips with the overall size and structure of the UK Real Estate Market</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn and analyse the links between the different parts of the property market</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand who works in the Real Estate Market, their qualifications and their job descriptions</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc&hellip;</li><li value="6" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn how to read a real estate market report</li><li value="7" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Understand how current affairs, politics and economics affects Real Estate Investment</li><li value="8" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Professionals outside the field (e.g. Lawyers, Lenders, Recruitment Professionals, Public Servants etc.) who regularly work with property companies</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Customer Service Employees who interacts with Real Estate Firms</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Junior employees in the HR department of Real Estate Firms Professionals in other sector interested in changing their career path to the Real Estate sector</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Recent non-cognate Graduates interested in entering the field of Real Estate</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Morning</strong></strong></em></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Real Estate or Property?</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">What is Real Estate - Physical characteristics &amp; Investment characteristics</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Why buy Real Estate?</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">How big is the UK Real Estate market? - Total size and size of various sub sectors</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Key Real Estate Market Locations, Sale Prices and Rents</li><li value="6" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">The Property Market system - The Occupier market, The Investment market, The Property Development market, The Land market &amp; How the four markets interact and make money</li><li value="7" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">How to calculate Sale Price and Real Estate Returns</li><li value="8" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">How to read a Real Estate market report</li><li value="9" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">How many famous properties do you know? - How much did they cost to build? Who occupies these buildings? Are they good value for money?</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Afternoon</strong></strong></em></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Who works in Real Estate and what do they do?</li><li value="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Typical Real Estate CVs - Education and Experience, Professional bodies and accreditations &amp; Typical career paths</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Real Estate Professionals and the Real Estate Lifecycle - The Investment lifecycle &amp; The Development lifecycle</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Real Estate Companies&rsquo; - Types of property company, Organisational structure, Typical wages and employment benefits, Accessibility, CSR and Diversity &amp; Related industries</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Real Estate Networks</li><li value="6" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">The future of Real Estate</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">CPD Accredited Certificate</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Course Files</li><li value="4" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the An Introduction to Real Estate such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



A one-day course to help you understand the real estate sector, its characteristics and its importance to the general economy. This course will help anyone supporting or moving into the sector with the knowledge and tools to communicate effectively with real estate professionals. By the end of the course delegates will have gained key skills in Real Estate Investment strategy and Analytics. They will also become familiar with the players, structure, general terminology and overall needs of Real Estate.


On this course, you will…
Learn what is Real Estate and why it is different from other asset classes
Get to grips with the overall size and structure of the UK Real Estate Market
Learn and analyse the links between the different parts of the property market
Understand who works in the Real Estate Market, their qualifications and their job descriptions
Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc…
Learn how to read a real estate market report
Understand how current affairs, politics and economics affects Real Estate Investment
Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector


Who will benefit from this course?
Professionals outside the field (e.g. Lawyers, Lenders, Recruitment Professionals, Public Servants etc.) who regularly work with property companies
Customer Service Employees who interacts with Real Estate Firms
Junior employees in the HR department of Real Estate Firms Professionals in other sector interested in changing their career path to the Real Estate sector
Recent non-cognate Graduates interested in entering the field of Real Estate


Course Outline
Morning
Real Estate or Property?
What is Real Estate - Physical characteristics & Investment characteristics
Why buy Real Estate?
How big is the UK Real Estate market? - Total size and size of various sub sectors
Key Real Estate Market Locations, Sale Prices and Rents
The Property Market system - The Occupier market, The Investment market, The Property Development market, The Land market & How the four markets interact and make money
How to calculate Sale Price and Real Estate Returns
How to read a Real Estate market report
How many famous properties do you know? - How much did they cost to build? Who occupies these buildings? Are they good value for money?


Afternoon
Who works in Real Estate and what do they do?
Typical Real Estate CVs - Education and Experience, Professional bodies and accreditations & Typical career paths
Real Estate Professionals and the Real Estate Lifecycle - The Investment lifecycle & The Development lifecycle
Real Estate Companies’ - Types of property company, Organisational structure, Typical wages and employment benefits, Accessibility, CSR and Diversity & Related industries
Real Estate Networks
The future of Real Estate


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


For more information about the An Introduction to Real Estate 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

 This course will help anyone supporting or moving into the sector with the knowledge and tools to communicate effectively with real estate professionals. 

An Introduction to Real Estate (Foundational Level)

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is aimed at people in senior roles including CIOs, chief digital officers and other aspiring CxOs, as well as consultants and others involved in digital transformations, service delivery and strategic delivery.</p>Overview<p>By the end of this course, you will understand: The internal and external factors to consider while crafting digital strategy How IT strategy differs from digital strategy and how they can be integrated Creating a digital strategy that achieves the most value from digital Implementing and sustaining digital strategy Developing and nurturing digital capabilities for continual business innovation and value co-creation</p><p>This course takes you on a digital strategy journey. Its iterative, eight-step model moves from ?vision? through to ?actions? and is about creating sustainable, digital momentum. You experience the four key capabilities to develop a holistic, digital capability framework: digital leadership, managing innovation and emerging technologies, risk management and structuring a digital enterprise. <strong>This class includes an exam voucher.</strong></p>Prerequisites<p>Delegates attending this course must have successfully achieved the ITIL 4 Foundation Qualification; your certificate must be presented as documentary evidence to gain admission to this course. Although there is no mandatory requirement, ideally candidates should have at least two years professional experience working in IT Service Management.</p></div><div id="course-pills-2"><h3>1 - ITIL GUIDING PRINCIPLES TO ALL ASPECTS OF DIGITAL AND IT STRATEGY</h3> <ul> <li>Focus on Value</li> <li>Start Where You Are</li> <li>Progress Iteratively with Feedback</li> <li>Collaborate and Promote Visibility</li> <li>Think and Work Holistically</li> <li>Keep It Simple and Practical</li> <li>Optimise and Automate</li> </ul> <h3>2 - LEVERAGE DIGITAL STRATEGY TO REACT TO DIGITAL DISRUPTION</h3> <ul> <li>Digital Technology</li> <li>Digital Business</li> <li>Digital Organisation</li> <li>Digitisation</li> <li>Digital Transformation</li> <li>Business Strategy and Business Models</li> <li>Digital and IT Strategy</li> <li>Products</li> <li>Services</li> <li>Relationship Between Digital, IT Strategy and Components of ITIL SVS.</li> </ul> <h3>3 - RELATIONSHIP BETWEEN CONCEPTS OF DIGITAL AND IT STRATEGY, SERVICE VALUE SYSTEM AND SERVICE VALUE CHAIN</h3> <ul> <li>Environmental Analysis</li> <li>External Analysis: PESTLE</li> <li>Internal Analysis: Four Dimensions of Service Management</li> </ul> <h3>4 - HOW AN ORGANISATION USES DIGITAL AND IT STRATEGY TO REMAIN VIABLE IN ENVIRONMENTS</h3> <ul> <li>How an Organisation?s Viability is Related to Agile, Resilient, Lean, Continuous and Co-Creational it is</li> <li>How to Analyse the VUCA Factors and Address them in a Digital and IT Strategy</li> <li>Organisation?s Position in a Particular Market or Industry</li> <li>Digital Positioning Tool to Determine Appropriate Position for a Digital Organization</li> </ul> <h3>5 - EXPLAIN AND COMPARE THREE LEVELS OF DIGITAL DISRUPTION</h3> <ul> <li>Ecosystem</li> <li>Industry/Market</li> <li>Organisational</li> <li>Influenced factors</li> <li>Achieving Customer/Market Relevance</li> <li>Achieving Operational Excellence</li> <li>Internal and External Focus</li> <li>Balanced Approach</li> </ul> <h3>6 - STRATEGIC APPROACHES BY DIGITAL AND IT TO ACHIEVE CUSTOMER/MARKET RELEVANCE AND OPERATIONAL EXCELLENCE</h3> <ul> <li>How to Apply Approaches to Achieve Customer/Market Relevance</li> <li>Customer Journeys</li> <li>Omnichannel Delivery and Support</li> <li>Context-Sensitive Delivery and Support</li> <li>Customer Analytics</li> <li>Customer Feedback and 360Ã¸ Approaches</li> <li>How to Achieve Operational Excellence in the Four Dimensions of Service Management</li> <li>Understand the Financial Aspects of Digital and IT Strategy in Terms of the Following</li> <li>Financial Policies</li> <li>Portfolio Optimization</li> <li>Funding Projects, Products and Services</li> <li>Balancing Cost of Innovation and Operation</li> <li>Charging Models</li> <li>Assess Strategic Approaches for Digital Organizations</li> </ul> <h3>7 - RISKS AND OPPORTUNITIES OF DIGITAL AND IT STRATEGY</h3> <ul> <li>Concept of Risk Management in the Context of a Digital Organisation</li> <li>Context of Digital and IT Strategy</li> <li>Identify Risk</li> <li>Assess Risk</li> <li>Concept of Risk Posture and Show How to Determine an Acceptable Balance Between Opportunity and Risk</li> <li>Explain the Concept of Innovation, Including its Key Elements and Techniques</li> <li>Apply Techniques to Develop and Maintain a Culture of Innovation</li> </ul> <h3>8 - STEPS AND TECHNIQUES INVOLVED IN DEFINING AND ADVOCATING FOR DIGITAL AND IT STRATEGY</h3> <ul> <li>How to Use Digital Readiness Assessment to Perform Gap Analysis Between an Organisation?s Current and Desired Positions Approaches for Scraping Data from Dynamic Websites</li> <li>How to Define and Communicate a Vision and a Strategy</li> <li>How to Use Business Cases to Advocate for a Digital and IT Strategy</li> </ul> <h3>9 - IMPLEMENTATION OF A DIGITAL AND IT STRATEGY</h3> <ul> <li>How to Define Operating Models for Digital Organisations</li> <li>Major Skills Required of Leaders in Digital Organisation</li> <li>Apply Approaches to Strategy Coordination and Implementation:</li> <li>Large-Scale Transformation</li> <li>Incremental Transformation</li> <li>Mergers and Acquisitions</li> <li>Individual Changes</li> <li>Approaches to POMs (Parallel Operating Models)</li> <li>How to Assess Success of a Digital and IT Strategy</li> <li>Typical Activities of a Digital Transformation Programme</li> </ul></div>

ITIL

Design & Technology Courses (DT)

IT (Information Technology)

Institute of Leadership & Management (ILM)

ICDL (International Certification of Digital Literacy)

<h4 style="color: rgb(12, 46, 63); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(12, 46, 63);">Hello and thank you for joining us.</h4><h4 style="color: rgb(12, 46, 63); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(12, 46, 63);">In this WebWorkshop, you will learn:</h4><ul style="color: rgb(12, 46, 63); box-sizing: border-box;" fr-original-style=" color: rgb(12, 46, 63);"><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">How to get everyone home safe every day.</p></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">How to shift from &lsquo;doing&rsquo; safety to &lsquo;being&rsquo; safe.</p></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">How to accommodate humans for being human.&nbsp;</p></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">How the definition of safety must move beyond the physical to include psychological, emotional and spiritual.</p></li></ul><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">We run these WebWorkshops in a way which makes the information stick. You will not get an hour of PowerPoint slides, and instead will be taken on a journey through what Compassionate Safety is and what it can achieve.</span></div>

Hello and thank you for joining us.In this WebWorkshop, you will learn:
How to get everyone home safe every day.
How to shift from ‘doing’ safety to ‘being’ safe.
How to accommodate humans for being human.
How the definition of safety must move beyond the physical to include psychological, emotional and spiritual.
We run these WebWorkshops in a way which makes the information stick. You will not get an hour of PowerPoint slides, and instead will be taken on a journey through what Compassionate Safety is and what it can achieve.

Ppwd Consulting

PPWD’s Compassionate Safety approach generates environments that accommodate humans for being human. Our approach aligns personal and organisational mindsets, beliefs and values. In doing so, workplaces are created where people thrive and flourish.

90 Courses in Belfast

Let's Talk About Race (EDI)

By Mpi Learning - Professional Learning And Development Provider

Policy & Procedure Writing

By Mpi Learning - Professional Learning And Development Provider

Microsoft Project Advanced - In-company (now with trainer led live online classes)

By Microsoft Office Training

Microsoft Project Introduction - In-company

By Microsoft Office Training

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

Microsoft Project Introduction/Intermediate - In-company

By Microsoft Office Training

Microsoft Word Intermediate - In-company (now with live online classes)

By Microsoft Office Training

Microsoft Excel Introduction - In-company

By Microsoft Office Training

Microsoft Excel Intermediate - In-company

By Microsoft Office Training

Microsoft Excel Advanced - In-company

By Microsoft Office Training

Search By Location